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
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.