SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Adding previous users after Database refresh
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kumarich1
Yak Posting Veteran

99 Posts

Posted - 05/14/2008 :  08:50:06  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  09:44:08  Show Profile  Reply with Quote
Do you mean after restore?
Go to Top of Page

kumarich1
Yak Posting Veteran

99 Posts

Posted - 05/14/2008 :  09:47:15  Show Profile  Reply with Quote
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.
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 05/14/2008 :  10:34:12  Show Profile  Reply with Quote
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?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 05/14/2008 :  23:37:34  Show Profile  Reply with Quote
>> if there is any script which generates user permissions

You can script them before restoring db.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000