Post reply

Looking for script(s) or free tool(s) to clone a user access

  • April 10, 2008 at 1:33 pm

    #185310

    Looking for script(s) or free tool(s) to clone a user access. For example, make a new user (LoginB) the same access as an existing user (loginA). It should include the server role(s), default DB, database level access, and object level permissions.

    Any suggestions? For both SQL2005 and SQL2000.

  • April 10, 2008 at 2:27 pm

    #801184

    yeah no easy feat! I have code which will clone a user or set of users but only to role level, not to object level. Best of luck!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 25, 2008 at 10:15 am

    #807295

    Idera SQLpermissions does the job. Just be aware of the new user/login has an empty password.

  • April 25, 2008 at 10:22 am

    #807300

    I could not find the tools or scripts at the beginning. That makes me think why it is not there. Then I realized the reason could be why clone users? Why not use group or role instead? It is silly to duplicate many users.

    Anyway, SQLpermissions is pretty neat and handy whenever we have to do so.

    Free tool 🙂

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

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