Link to home
Create AccountLog in
Avatar of gateguard
gateguard

asked on

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.

ASKER CERTIFIED SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gateguard
gateguard

ASKER

thanks