Options
How do I transfer users and permissions over?
patricksteiner
Posts: 2
Hello,
I can't seem to find any information on this through searches so I hoping someone has already resolved this. I have SQL Compare and SQL Data Compare, but I cannot seem to get the user permissions to copy. I can copy the logins and database users (with default passwords). How do I get the roles and permissions to come across as well? Thank you for your patience if this is a newbie question.
I can't seem to find any information on this through searches so I hoping someone has already resolved this. I have SQL Compare and SQL Data Compare, but I cannot seem to get the user permissions to copy. I can copy the logins and database users (with default passwords). How do I get the roles and permissions to come across as well? Thank you for your patience if this is a newbie question.
Comments
Firstly - permissions are copied in SQL Compare with the object that the permission relates to, not with the user. Have you been selecting the objects which the permissions relate to, or just the users?
Secondly - there are some options which affect whether permissions are copied or not. Have a look at the Options tab in the Edit Project dialog for your project and check the ignore options 'Permissions' and 'Users' permissions and role memberships' - if one of these is turned on, your user permissions won't be copied.
Redgate Software
I tried syncing the changes (less the users) but it gives errors (due to the users not being in the database(s) where the objects are attempting to be created).
I'm Running SQL Compare 11.5.0.126.