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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 same access previleges like one user

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-10-11 : 14:31:39
Hi Experts,
i've a login A, having some db roles on an instance. now there is another login B, needs the same previlleges

what is the best way to give same previleges to B?

please suggest me

Arnav
Even you learn 1%, Learn it with 100% confidence.

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-11 : 15:30:23
you should be creating a role and grant all the priviledges to the role

You just then add or remove users from that role

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx





Go to Top of Page
   

- Advertisement -