hi friends,

I would like to know how can we extract the permissions on all the Stored procedures of a sybase database. I know sp_helpprotect <procedure_name> will give the permissions on the specific sp. Is there any way to get permissions on sp on database level.

-- akhilesh

check table sysprotects
select object_name(a.id),user_name(a.uid),a.action from sysprotects a, sysobjects b
where a.id=b.id
and b.type ="P"

check sysprotects description in
SyBooks Online