October 12, 2018 at 11:31 am
I have Server Premium_stg and I want to copy all logins and user Permission and role for each DB to Premium_Dev server
How can I generate for 25 DB all role permission to each user
October 16, 2018 at 2:18 pm
Role memberships are easy enough
select u.name, r.name
from sys.server_principals u join
sys.database_role_members rm on u.principal_id = rm.member_principal_id join
sys.database_principals r on rm.role_principal_id = r.principal_id
October 17, 2018 at 8:43 am
Nita Reddy - Friday, October 12, 2018 11:31 AMI have Server Premium_stg and I want to copy all logins and user Permission and role for each DB to Premium_Dev serverHow can I generate for 25 DB all role permission to each user
see my script at this link
http://www.sqlservercentral.com/scripts/Server+Roles/178807/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply