how to check permissions on a table in sybase ase

sybase sap-ase
niru dyogi picture niru dyogi · Aug 19, 2013 · Viewed 36.4k times · Source

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?.

Answer

Michael Gardner picture Michael Gardner · Aug 21, 2013

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

Related questions

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More
list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?

Read More
How do I look at column metadata in Sybase?

I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to? (…

Read More