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.

Is that doable?

timc (tcaylor@thomasnelson.com) writes:
> 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.

Run sp_helprotect on the procedure from Query Analyzer.



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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp