Search code examples
sybasesap-ase

how to check permissions on a table in sybase ase


how to check permissions on a table in sybase ase 15-2. I wan to check all the existing permissions on 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?.


Solution

  • sp_helpgroup will list groups in the current database.

    sp_helpgroup GROUPNAME will list the groups members.

    sp_helprotect TABLENAME will list the permission details (must be a table in the current database)

    sp_helprotect USERNAME will list user's permission details

    Please take a look at some the Sybase System Administration Guides 1 & 2. As a new user to ASE, you will find many of your answers there.

    System Admin Guide 1

    System Admin Guide 2

    SyBooks Online for ASE