[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

SQL 2005 Instances Security On Same Server

If I have a default instance of SQL 2005 server on a Windows 2003 Server box, and I add a couple of named instances, and some of the users are duplicated throughout the different instances, can I be sure that the Server Roles I give to a user in one instance won't give that user the same role in another instance?

Example, on a server named ACT:

Server............User..............................Role
ACT................domain1\user1.............none
ACT\RED........domain1\user1..............none
ACT\GREEN...domain1\user1..............Sysadmin

Can I be sure that the domain1\user1 login does NOT have sysadmin on the named instance ACT\RED, or in the default instance?

It seems that way.  I'm just checking here to be sure.

0
gateguard
Asked:
gateguard
1 Solution
 
dqmqCommented:
Yes, you can be sure.  Server roles are maintained by server and database roles are maintained by database.  Never will the permissions granted to a role in one instance apply to the same role in another instance.
0
 
gateguardAuthor Commented:
thanks
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now