CODEWITHSUNDEEP
sqlsql-servert-sqlsystem-administrationsa
Novice Programmer
Novice Programmer

Reputation: 423

Is there a way to stop the 'sa' user changing records inside particular table or particular db in mssql?

Is there a way to stop the 'sa' user changing records inside particular table or particular db in mssql? My preliminary searches did not find me anything except cell level encryption. Is there any other way?

UPDATE

Requirement is to prevent IT users changing (inserting) records to gain access to system. other users can be prevented by restricting permission. but 'sa' user cannot. replacing sa with another account won't work as the person who has the other account would have potential to do the change and gain access.

Upvotes: 0

Views: 47

Answers (1)

Vikramsinh Shinde
Vikramsinh Shinde

Reputation: 2878

Best practice guideline on 'sa' account by Microsoft:

Resource

Also you can replace 'sa' with some other account with elevated premission

Replacing the SQL Server Default SA Account

Upvotes: 1

Related Questions