September 8, 2010 at 3:57 pm
Hi All,
I need to grant the same user permission to other user, how can i do that, any handy script in SQL SERVER 2008.
eg:
UserA has some x,y... privileges,
Same priviliges should be given to New user B.
How can i do this, and i need to view the privileges user A has?
Regards
Jak 🙂
@JayMunnangi
September 8, 2010 at 4:11 pm
First, never grant privileges to users. Create a role, grant rights to the role, add users to the role. You do this for the exact reason that you are trying to solve. Someone else will always need rights.
Second, to view permissions, you can use sys.fn_my_permissions
July 24, 2012 at 8:27 am
July 25, 2012 at 9:11 am
See the below url for an Instance Security Audit script (has for 2005 and above, and another for SQL 2000) that I wrote. Shows the roles and individual object permissions, and allows you to change a variable and get the actual statements to assign them, for all databases in an instance.
I agree that you should use roles to assign specific permissions to, and then just assign the roles to the users. Makes it much easier to then give another user the same permissions, just assign them the same role.
http://www.sqlservercentral.com/Forums/Topic1251262-146-1.aspx
Hope it helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply