Link to home
Start Free TrialLog in
Avatar of iamuser
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?
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Avatar of iamuser
iamuser

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.
ASKER CERTIFIED SOLUTION
Avatar of Racim BOUDJAKDJI
Racim BOUDJAKDJI
Flag of Algeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial