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.
Can you use the Generate SQL in Enterprise Manager to script the existing permissions, then find & replace the permissions for the User you want to copy-from?
Personally this sounds like a job for a Role, but you've stated you don't want to use one.
I'm with Kristen on this one. You want two people to share the same role but don't want to use the Role concept. Can you elaborate on your reasons for this?
HTH
================================================================= 'Tis with our judgements as our watches: none Go just alike, yet each believes his own. -Alexander Pope, poet (1688-1744)
User's and Object level permissions
Forum Locked
Posted - 06/26/2005 : 00:50:12
