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

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"

SAP IQ 16

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