- A stored procedure owned by a non-DBA user.
- The procedure inserts data into a dbo table.
- The non-DBA user has not insert permission on the dbo table.
When DBA calls the stored procedure, permission error below is fired:
Could not execute statement. Permission denied: you do not have permission to insert into "s1_IQ"
SQLCODE=-121, ODBC 3 State="42000"
SAP IQ 16
sybase, permission, invoker, definer, security, procedure , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.