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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply