I have a work task of producting commands that are defined as "DBADM"
commands (of which I am considering this SA only/ and dbo only
commands)? Is there a specific list of these commands? Is there a
query that will produce only tsql commands (including kill, and the
like) that are only available to sa_role?

Thank you in advance,

Kermit Lowry, III
"Only you can prevent forest fires!!!"
kermit dot lowry at kpbad dot com

remove bad to send

"Kermit Lowry" <kermit.lowry (AT) kp (DOT) org> wrote


There is no query or stored proc to list all commands with such required
permissions, since these are built in to ASE (and not stored in
sysprotects).
The ASE Reference Manual lists all permissions in painstaking detail
though...

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------