Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Roomurray
Starting Member
4 Posts |
 Posted - 2011-04-08 : 06:51:02
|
| Is it possible to copy a user in a particular database and to have all the database level securables to remain the same as the copied user? If so is there a easy way to go out it? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-08 : 07:03:16
|
| http://www.databasejournal.com/features/mssql/article.php/2228611/Migrating-Logins-from-One-SQL-Server-to-Another.htm--------------------------http://connectsql.blogspot.com/ |
 |
|
|
Roomurray
Starting Member
4 Posts |
Posted - 2011-04-08 : 07:09:41
|
But I'm only wanting to create another user (duplicate) within the database. With the same securible rightsquote:
Originally posted by lionofdezert
http://www.databasejournal.com/features/mssql/article.php/2228611/Migrating-Logins-from-One-SQL-Server-to-Another.htm--------------------------http://connectsql.blogspot.com/
|
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-08 : 07:30:12
|
| http://connectsql.blogspot.com/2011/04/sql-server-script-to-create-replica-of.html |
|
|
|
|
|
|
Copy user at database level