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
Can I change the SA account on a single database? or does it replicate to the whole of the database's
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am assuming that there are dependency’s relying on the SA account which would need to be changed?
ASKER
trofimoval...Sorry I ment password. I didnt think so but now I know.
Thanks guys.
Thanks guys.
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
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
ASKER
Thanks, I thought so.