September 14, 2008 at 9:33 pm
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
September 15, 2008 at 1:41 am
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply