Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scripting the Object Permissions
Message
De
24/01/2007 07:35:48
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01188296
Message ID:
01188562
Vues:
12
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform