Identifying dependent objects with sp_depends  Chapter 17: Using Extended Stored Procedures

Chapter 16: Using Stored Procedures

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)




Copyright © 2005. Sybase Inc. All rights reserved. Chapter 17: Using Extended Stored Procedures

View this book as PDF