[Error] SQL Anywhere Error -265: Procedure ‘sp_iqstatus’ not found.
DBA user failed to execute a procedure with the following error message.
– Msg 504, Level 11, State 0: SQL Anywhere Error -265: Procedure ‘sp_iqstatus’ not found
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).
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;