Improve company productivity with a Business Account.Sign Up

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

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?
0
iamuser
Asked:
iamuser
1 Solution
 
James MurrellProduct SpecialistCommented:
0
 
iamuserAuthor Commented:
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.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<Is this normal? >>Yes. Assuming SA means *sysadmin* and all users are publi db roles, all of them still have life and death rights over the database....  The only way for you to tighten security is to take away sysadmin rights from regular users.  Just a not: we currently have 200 instances with more than 500 dev.  Only 10 people are sysadmin and 5 know the sa...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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