SAP Knowledge Base Article - Preview

3581951 - Permission denied error is reported on a table when executing a Stored Procedure - SAP IQ

Symptom

You will get Permission denied error under the below conditions:

  1. A stored procedure owned by a non-DBA user.
  2. Some tables owned by someone other than the stored procedure owner is used within the stored procedure.
  3. The stored procedure owner has not suitable permission for these tables in the stored procedure.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

Permission denied, stored procedure, SP, table, owner, SELECT ANY TABLE , KBA , BC-SYB-IQ , Sybase IQ , How To

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.