Access permissions on stored procedures.

Hi All
Is there a way to find out what access permissions have been granted to all
stored procedures in my database? Thank you in advance.sp_helprotect returns all permissions in the current database. To see only
stored procedures, you could put the results into a temporary table and
delete all but EXECUTE grants, which will leave stored procedures and
scalar-valued functions. Try this:
CREATE TABLE #p (Owner sysname,
Object sysname,
Grantee sysname,
grantor sysname,
ProtectType varchar(10),
Action varchar(20),
[Column] sysname);
INSERT INTO #p EXEC sp_helprotect @.permissionarea = o;
DELETE #p WHERE Action <> 'Execute';
SELECT * FROM #p;
DROP TABLE #p;
HTH
Vern
"MittyKom" wrote:

> Hi All
> Is there a way to find out what access permissions have been granted to al
l
> stored procedures in my database? Thank you in advance.
>