General syntax for sp_helpProtect is
sp_helprotect [ [ @name = ] 'object_statement' ] [ , [ @username = ] 'security_account' ] [ , [ @grantorname = ] 'grantor' ] [ , [ @permissionarea = ] 'type' ]
You may use it in following ways
--List all user permissions of all Database objects sp_helprotect GO -- List all user permissions of a table sp_helprotect 'tableNme' GO -- List all user permissions of stored procedure EXEC sp_helprotect 'spName' GO -- List all user permissions of sp granted by dbo sp_helprotect 'spName', NULL,dbo GO -- List all Object type user permissions sp_helprotect NULL, NULL,NULL,'o' GO -- List all statement type user permissions sp_helprotect NULL, NULL,NULL,'s' GO -- List all permissions for a user sp_helprotect NULL,'user' GO
Note: Basically sp_helprotect is for SQL Server 2000.For SQL Server 2005 and later sp_helprotect has no information regarding securables that were introduced in SQL Server 2005. Read here about List the permissions on SQL Server 2005 objects by using sys.database_permissions and fn_builtin_permissions instead.