Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying Security Roles
Message
 
 
À
06/10/2004 22:34:47
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00949418
Message ID:
00949750
Vues:
13
This message has been marked as the solution to the initial question of the thread.
In the Enterprise Manager (EM), right click on the source database (DB) and slect AllTasks -> Generate SQL Script, select Options tab, check Script database users and database roles, select File Format and click OK to generate a script. Review the script generated, make neccessary adjustments and run it for destination DB.

>Good morning! Does anyone know how I can copy the security roles of one database to another database in the same server?
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform