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

Search for additional results

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