SAP Knowledge Base Article - Preview

2377092 - SAP IQ. Permission error on a table when calling a Stored Procedure

Symptom

  1. A stored procedure owned by a non-DBA user.
  2. The procedure inserts data into a dbo table.
  3. 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"

 


Read more...

Environment

SAP IQ 16

Product

SAP Sybase IQ 15.4

Keywords

sybase, permission, invoker, definer, security, procedure , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.