Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

permissions Expand / Collapse
Author
Message
Posted Thursday, July 3, 2008 1:35 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 17, 2010 12:39 AM
Points: 935, Visits: 72
we have one production server and one web server.web server is restore once in day. i want restore the same logins and permissions from production to web...
please any one help me..how to do
Post #528362
Posted Thursday, July 3, 2008 1:40 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:42 AM
Points: 646, Visits: 732
Is this something you need:
http://support.microsoft.com/kb/246133


Maninder
www.dbanation.com
Post #528365
Posted Thursday, July 3, 2008 11:36 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 17, 2010 12:39 AM
Points: 935, Visits: 72
thanks mani

i did same thing .. but its transfered logins ..
i am restoring database daily ..so permission is not restoring ..
so i need script to transfer permission after restore

Post #528490
Posted Thursday, July 3, 2008 11:43 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 17, 2010 12:39 AM
Points: 935, Visits: 72
thanks mani

i did same thing .. but its transfered logins ..
i am restoring database daily ..so permission is not restoring ..
so i need script to transfer permission after restore

Post #528491
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse