How to check table permissions in sybase ase

Question

how to check permissions on a table in sybase ase 15-2. I want to check all existing permissions for a table.

I tried exec sp_helprotect 'dbo.mytable' 

Also how to check what are all groups are having what are all permissions on a table? .

Answer 1

sp_helpgroup display the groups in the current database.

sp_helpgroup GROUPNAME displays a list of members.

sp_helprotect TABLENAME will display permission information (there must be a table in the current database)

sp_helprotect USERNAME will display user permission information

Please see some Sybase 1 and 2 system administration guides. As a new ASE user, you will find many of your answers there.

System Administrator Guide 1

System Administrator Guide 2

SyBooks Online for ASE

Answer 2

There is a sysprotects system table where all user and group permissions are stored. You can join sysusers for results.

SP: sp_helprotect provides the necessary information.