Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 User's and Object level permissions
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

32 Posts

Posted - 06/26/2005 :  00:50:12  Show Profile
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,


United Kingdom
22859 Posts

Posted - 06/26/2005 :  19:01:57  Show Profile
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.

Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 Posts

Posted - 06/27/2005 :  15:35:24  Show Profile
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?


'Tis with our judgements as our watches: none Go just alike, yet each believes his own. -Alexander Pope, poet (1688-1744)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000