SAP Knowledge Base Article - Preview

2998182 - Error 10330 on cross-database queries after upgrade to version 16 - SAP ASE

Symptom

Error 10330 on cross-database queries after upgrade to version 16 despite running "dbcc upgrade_object" on all the compiled objects:

====

Msg 10330, Level 14, State 1:
Server 'asesp02pl8', Procedure 'delcascadetrg1', Line 5:
DELETE permission denied on object tb04, database db02, owner dbo

=====

The stack trace on memory dump:
 
=====

...
...
exc_callprint
check__protect
prot_driver
rvm__check_grant_revoke_access
rvm_dispatch
rvm_process_dispatch
s_execute
sequencer
execproc
s_execute
...

=====


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

error 10330 permission denied cross-database queries upgrade check__protect prot_driver rvm__check_grant_revoke_access rvm_dispatch rvm_process_dispatch CR 822370 CR822370 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.