Get permissions for stored procedure in sybase

Question

How do I get the granted permissions for a stored procedure in sybase?

Answer 1

It depends on the form that you want that info in.

• If you are writing SQL for some internal purpose, and you need that info as data for it, Kolchanov's answer is correct.
• If you are merely performing DBA functions, then any number of DBA GUI tools (SybaseCentral comes with the CD; DBArtisan is much better) provide that info via an explorer window and clicks
  • If you only have character based access, use
    sp_helprotect proc_name

Link to Sybase Online Manuals

Then go to: Adaptive Server Enterprise 15.5/Reference Manual: Procedures, nd follow the explorer.