[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).

—————————————-

group_name,member_name

‘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;

==

HTH

Gi-Sung Jang