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
