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 ONE Support launchpad (Login required).

Search for additional results

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