sql server sa account modify permisions

Question

is it possible to alter the permissions of the actual sa account in sql server

Answer 1

No. It is not possible to alter the permissions of the SA account in SQL Server. You can disable the sa login, if you want.

Answer 2

Hi @NeophyteSQL ,

is it possible to alter the permissions of the actual sa account in sql server

No. It is not. Sysadmin is one of the fixed server-level roles, SQL Server provides nine fixed server roles. And the permissions that are granted to the fixed server roles (except public) cannot be changed.

Why do you want to you to change SA account's permission? If you have new logins and new users, you can create a new role and then grant them the suitable permissions. Of course, firstly, you need to have the grant permission. If you do not, you can ask your SA to chieve that.

More information: sql-server-create-login-user-role-and-assign-permission

Note:
Beginning with SQL Server 2012 (11.x), you can create user-defined server roles and add server-level permissions to the user-defined server roles.

BR,
Mia

Answer 3

Hi @NeophyteSQL ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.