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

copy permission of a logins to a different server Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 10:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:35 PM
Points: 328, Visits: 854
I have a server A and a Server B. An user call SQLuser on both Serves. Both Server A and B has same sets of databases and table.

On server A, I've given permission to serveral objects (databases/tables) to SQLuser. How can I copy that permission to SQLUser on Server B?
Post #1494278
Posted Friday, September 13, 2013 2:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 4:07 AM
Points: 5, Visits: 174
Hi,

Let me recommend you this free tool:

http://www.idera.com/productssolutions/freetools/sqlpermissionsextractor?utm_source=sqlcheck&utm_medium=inproduct&utm_campaign=sqlfreetools&utm_content=tab

Free Tool SQL Permissions Extractor. FREE extraction and migration of permissions from objects in SQL:

•Generate T-SQL scripts for copying of user permissions
•Edit, save, and execute permissions scripts
•Include object level permissions for selected databases
•Four steps to copy, extract, modify and apply changes

Regards.
Post #1494505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse