Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinayj
Starting Member
32 Posts |
 Posted - 2005-06-26 : 00:50:12
|
| 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.Any Help, |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-06-26 : 19:01:57
|
| 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.Kristen |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-06-27 : 15:35:24
|
| 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