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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:30 AM
Points: 403, Visits: 982
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 @ 10:18 AM
Points: 5,886, Visits: 13,041
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