24 December,2014 by Tom Collins
Question: How can I delete the “sysadmin” server elevated role from a SQL Server login?
Answer: There are two standard methods to drop a sql server login from the sysadmin server role.
Using the following code as a template. Apply the SQL Server Login and execute the code against the SQL Server
ALTER SERVER ROLE [sysadmin] DROP MEMBER [My Domain\My SQL Server Login] GO
To delete the alter the SQL Server login privileges.
ALTER AUTHORIZATION sql to change owner of a database
How to create a SQL Server Security Audit
Powershell sql server security audit
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |