jdhackett
asked on
Copy SQL Security
Using SQL Server 2000.
I have a new database, which has the exact same structure as an existing database. The data is different, but same Tables, View and Stored Procedures.
Anyway, I'l like to copy the security model from the existing into the new database- same roles, groups etc.
How would I do this?
Thanks
I have a new database, which has the exact same structure as an existing database. The data is different, but same Tables, View and Stored Procedures.
Anyway, I'l like to copy the security model from the existing into the new database- same roles, groups etc.
How would I do this?
Thanks
http://www.databasejournal.com/features/mssql/article.php/2228611
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
On the same server.
That copy users/roles method you suggested worked perfectly. I'll try the script for the permissions now, and let you know how I get on.
That copy users/roles method you suggested worked perfectly. I'll try the script for the permissions now, and let you know how I get on.