Sql to list all users in database 1

[tashend]

Does anyone out there maybe have a handy sql statement to return all logins on a Sybase server, the databases/tables they have access to and what type of access they have to each database e.g. select/insert etc

Unfortunately we are still on very old version ofe Sybase(11.0.3)

Thanks

 

[DotNetGnat]

yes..try this:

use DBName
exec sp_helpgroup GroupName

this lists group wise users present in each database...

-DNG

 

[DotNetGnat]

also...

to get all users in a particular database

exec sp_helpuser

look for these other stored procedures also...

select name,password from syslogins

sp_displaylogin UserName

exec sp_dispayroles UserName, expand_down


-DNG

 

[DotNetGnat]

also i have written a FAQ on this...take your time to go through it...

faq187-6042

-DNG