Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
View stored procedure permissions
0 views
Skip to first unread message
timc
Oct 29, 2004, 2:15:54 PM10/29/04
to
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?
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?
Erland Sommarskog
Oct 29, 2004, 5:23:41 PM10/29/04
to
Run sp_helprotect on the procedure from Query Analyzer.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
0 new messages