Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying Security Roles
Message
 
 
To
06/10/2004 22:34:47
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00949418
Message ID:
00949750
Views:
12
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform