Skip to Content
Author's profile photo Gi-sung Jang

[Error] SQL Anywhere Error -265: Procedure ‘sp_iqstatus’ not found.

1. Problem

DBA user failed to execute a procedure with the following error message.

[error message]

– Msg 504, Level 11, State 0: SQL Anywhere Error -265: Procedure ‘sp_iqstatus’ not found

2. Cause

If membership from “Group public” is removed from dba,

revoke membership in group public from dba;

DBA cannot execute procedures for the dbo owner even though dba has all the authorities.

You can see the group and membership from the sysgroups table.

> select * from sysgroups; //Public is a member in DBO group. And DBA is a member of Public. (DBO -> Public -> DBA).



‘PUBLIC’,    ‘DBA’

‘dbo’,            ‘PUBLIC’


3. Solution

It is necessary to restore the default and make PUBLIC a member in the dbo group again

or Grant dbo membership to dba directly.

– grant membership in group public to dba;



Gi-Sung Jang

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.