I have several logins in my server. The logins are mapped to certian databases as users. These users have some permissions on the objects i,e select ,update etc on tables and execute on sprocs.
Now I want to add a new login which has the previlages as one of the earlier one's. I want to do it without creating roles and adding users to roles.
Basically i want to generate a script in which i can get the object level permissions of a particular user(login) in all the databases so that i can only change the name of the user and run the script.