Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

stored procedures Expand / Collapse
Author
Message
Posted Sunday, September 14, 2008 9:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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,
Sandhya
Post #569236
Posted Monday, September 15, 2008 1:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:43 PM
Points: 2,109, Visits: 5,419
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

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #569267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse