Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scripting the Object Permissions
Message
From
24/01/2007 19:13:47
 
 
To
23/01/2007 15:15:56
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01188296
Message ID:
01189008
Views:
9
This message has been marked as the solution to the initial question of the thread.
For those interested, after looking on the MS SQL Server forum, aparently this is not possible in the current incarnation of SQL Management Studio. However, SQL Server SP2 is supposed to contain an upgrade which will allow setting of scripting options similar to how we did it in Enterprise Manager.

>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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Reply
Map
View

Click here to load this message in the networking platform