Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Identifying dependent objects with sp_depends [Table of Contents] Chapter 15 Using Extended Stored Procedures

Transact-SQL User's Guide

[-] Chapter 14 Using Stored Procedures
[-] Getting information about stored procedures
[-] Identifying permissions with sp_helprotect

Identifying permissions with sp_helprotect

sp_helprotect reports permissions on a stored procedure (or any other database object). For example:

sp_helprotect byroyalty
grantor    grantee    type  action    object    column  grantable
---------  ---------  ----  --------- -------   -----   ---------
dbo        public     Grant Execute   byroyalty All     FALSE
 
(return status = 0)

Identifying dependent objects with sp_depends [Table of Contents] Chapter 15 Using Extended Stored Procedures