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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-05-14 : 08:50:06
|
| Hi,I am doing a Training database refresh with production, after refresh I want to add users to training database who were in the training database originally.Can anybody send me if there is any script which generates user permissions, so I can run this script before refresh and apply the script after refresh, so I don't lose any users and user permissions.Thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 09:44:08
|
| Do you mean after restore? |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-05-14 : 09:47:15
|
quote:
Originally posted by sodeep
Do you mean after restore?
Yes before refresh generate script with all user permissions and add the script after refresh. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-14 : 10:34:12
|
| It depends on the permissions. We exclusively use role based permissions, for this reason. When you refresh a database, all you need to do is assign the proper roles to the affected users, and call it done. What sort of permissions are unique to the training users that are not in production? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 23:37:34
|
| >> if there is any script which generates user permissionsYou can script them before restoring db. |
|
|
|
|
|
|
Adding previous users after Database refresh