Post reply

User permissions to other login

  • November 23, 2011 at 3:32 am

    #252335

    Hi Friends,

    Please let us know , I have two logins , Login 'A' with some database user permission , i wanted to create new login with same model as 'A' but with different name , how we can achieve this?

  • November 23, 2011 at 3:43 am

    #1412038

    Either put the two logins in the same Windows group, or if they're SQL logins, use roles within the databases to assign permissions. This won't help you with the problem you have now, but if you adopt it as a general principle, it'll make administering permissions easier in the future.

    John

  • November 23, 2011 at 3:46 am

    #1412039

    My criteria is to transfer all database level permissions from login 'A' to login 'B' in the same server.

    B should be exactly mirror as A

  • November 23, 2011 at 4:20 am

    #1412057

    Easiest :-

    Create a group and give required permission.

    Add users A,B..............................Z to this group.

    Easy to manage, Easy to configure security, easy to remove.

    ----------
    Ashish

  • November 23, 2011 at 5:59 am

    #1412096

    crazy4sql (11/23/2011)

    Easiest :-

    Create a group and give required permission.

    Add users A,B..............................Z to this group.

    Easy to manage, Easy to configure security, easy to remove.

    exactly...when UserA or UserB get fired or move on, and you need to add UserC, then you simply add UserC to the Role.

    Permissions at the user level should be avoided...i'd venture to say never be assigned...ever.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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