Avatar of Bransby-IT
Bransby-IT
 asked on

SQL SA Account Question

SQL 2008

Can I change the SA account on a single database? or does it replicate to the whole of the database's
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Lara F

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Raja Jegan R

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Lara F

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bransby-IT

ASKER
Well I have just arrived at a company and most of the users have the password for the SA account?

Thanks, I thought so.
Bransby-IT

ASKER
I am assuming that there are dependency’s relying on the SA account which would need to be changed?
Bransby-IT

ASKER
trofimoval...Sorry I ment password. I didnt think so but now I know.

Thanks guys.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Lara F

This is not good practice to have everyone use sa.
Check what users need to do DBs, then you can give them specific rights.
Usually giving user "DB owner" rights on particular DB allow to do anything they need but  just with this DB.
Some may just be just fine with read/write