Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

stored procedures Expand / Collapse
Posted Sunday, September 14, 2008 9:33 PM


Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650
Hi to all,

I want to remove the public role from extended stored procedure.
could any one give some ideas regarding this.

And at the same time if i want to remove public role from a table i keep on doing it manually, but i want to know can we write a script regarding the same.

Thanks & regards,
Post #569236
Posted Monday, September 15, 2008 1:41 AM


Group: General Forum Members
Last Login: 2 days ago @ 7:13 AM
Points: 2,199, Visits: 6,042
You can write a small script with revoke key words in order to revoke permissions on working with an object. You can find more details (very easily) in BOL


To know how to ask questions and increase the chances of getting asnwers:

For better answers on performance questions, click on the following...
Post #569267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse