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

Script out Database users with roles/permissions Expand / Collapse
Author
Message
Posted Saturday, February 2, 2013 4:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:54 AM
Points: 393, Visits: 973
I have an need to take a list of users in a Database A with the same schema/permission/role settings and create them in another database .
I dont want to miss out on any of the permission for an user. How can i get that?
Post #1414969
Posted Saturday, February 2, 2013 4:51 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:55 AM
Points: 5,989, Visits: 12,927
check this out, read the discussion as well

http://www.sqlservercentral.com/scripts/Permissions/76450/


---------------------------------------------------------------------

Post #1414971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse