Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scripting the Object Permissions
Message
From
24/01/2007 07:35:48
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01188296
Message ID:
01188562
Views:
11
>>In the old SQL Enterprise Manager there was a scripting option that would script the object's permissions along with the object scripting when the object was scripted by EM.
>>
>>I have found no way to get SQL Management Studio to do this. Is there a way and if so, how?
>>
>>Thanks,
>>Bill
>
>Right Click on Table (or other object). Select Properties, Go to Permissions node of the treeview. Click on Script Button.

Hi Borissov,

Thanks, yes, I am familiar with this. What I want is when I select for the IDE to script an object ( E.g. a Stored Proc ), the scripting engine will script the object permissions at the same time like Query Analyzer used to do.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Reply
Map
View

Click here to load this message in the networking platform