Hi gurus I have to cerate a authenticated user and give the same permission to this user on particular database with an already existing user. Is there anyway that I can directly map permission. Instead doing things manually. I mean to say here that permission on the objects in that database. Thank You.
Try the script from the following link written by Vyas... http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm