iamuser
asked on
Have a user who can see the SA account when loging into SQL 2005
in my sql server i have 20 sql user accounts used for SA authentication.
Roles for 19 accounts are = public only. Remaining account is the default Sa account.
When i connect in with one of the user accounts, I don't see any of the other user accounts except the SA account. Not only can i see the SA account i can change settings inside of the account. Is this normal?
Is there a way to hide the SA account from the regular Sql user accounts?
Roles for 19 accounts are = public only. Remaining account is the default Sa account.
When i connect in with one of the user accounts, I don't see any of the other user accounts except the SA account. Not only can i see the SA account i can change settings inside of the account. Is this normal?
Is there a way to hide the SA account from the regular Sql user accounts?
have you read http://msdn2.microsoft.com/en-us/library/aa302337.aspx
ASKER
I looked at the article but i do not see it say anything about why the the SA account is being seen by the other sql accounts?
Those other local sql accounts are created by another application that we use.
Those other local sql accounts are created by another application that we use.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.