create user with privileges identical to another user

• cytodex

  Old Hand

  Points: 387

  More actions

  May 20, 2004 at 7:22 am

  #160942

  I would like to create a new user account for a database, wondering if I can use some stored procedure or the like to create it based on the privileges of another users (on tables, views, stored procedures and the like).

  Any customized stored Procedures ? Hints/tips/directions are welcome!

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  May 20, 2004 at 7:27 am

  #507126

  There might be one in the script library, but what you're asking for is a role. That's why roles exist and why you should use them.

  http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp