sql server (alternate): View stored procedure permissions -- sql server (alternate)

View stored procedure permissions

tcaylor NO[at]SPAM thomasnelson.com
10/29/2004 11:15:54 AM

sql server (alternate): We are running SQL Server 2000 Developer Edition. I don't want to
make the developers the sysadmin or even the dbo in the user
databases. Is there a way to give them access to only view the
permissions for the stored procedures in the user database without
making them dbo?

When I take them out of the db_owner role, when they open a stored
procedure they no longer see the permissions tab. I would like for
them to see the permissions tab and be able to view the permissions
but not change the permissions.

Re: View stored procedure permissions

Erland Sommarskog
10/29/2004 9:23:41 PM

timc (tcaylor@thomasnelson.com) writes:
[quoted text, click to view]

Run sp_helprotect on the procedure from Query Analyzer.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at