Post reply

Clone permissions of another user.

  • April 27, 2011 at 1:50 pm

    #389394

    Is there a way to find out what access and permissons a login has , i need to give another login exactly the same permissions it has?

    thanks

  • April 27, 2011 at 10:33 pm

    #1317025

    You can "reverse engineer" the user security and use this to create a new user. There are a few scripts floating around for this- you should be able to find one (depending on which SQL Server version you are using).

  • April 28, 2011 at 12:58 am

    #1317055

    You can get the information from syslogins table.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • April 28, 2011 at 1:24 am

    #1317063

    I also want to Know

    Thanks

  • April 28, 2011 at 4:11 am

    #1317126

    The link below has a comprehensive looking script which may give you the answer you are looking for.

    Can I suggest that you do not assign permissions to a user but assign them to a role and then add users to the role. Some time ago, I was tasked with assigning a complex set of permissions to a user and was persuaded by the DBA team lead to use a role instead. I was glad I followed his advice, even though I protested that is was just for one user, as two weeks later I was asked to give the same access to 10 others .....

    [/url]

    Hope this helps.

    Regards, Mark.

  • April 28, 2011 at 10:01 am

    #1317369

    Thank you!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply