Share via

Sysadmin - rights to write, modify and drop on all databases?

Bit-101 136 Reputation points
2021-11-12T09:26:21.543+00:00

Short question:
-Does Sysadmin has the rights to write, modify and drop on all databases that exist on a SQL server?

-Really appreciate your answer

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,471 questions
0 comments
Accepted answer
  1. Olaf Helper 46,041 Reputation points
    2021-11-12T09:45:34.103+00:00

    Members of the server role SysAdmin have all unlimited permissions on SQL Server and can do everything on server and database level.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Benard Mwanza 1,001 Reputation points
    2021-11-12T09:50:47.59+00:00

    The answer is YES, members assigned that role(SysAdmin), have all those abilities.

    To find out more about other granular roles, check out this article
    https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver15

    1 person found this answer helpful.
    0 comments
  2. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-11-15T02:39:30.91+00:00

    Hi Bit-101,

    How are things going?
    As other experts have said, members of the sysadmin fixed server role can perform any activity on the server, including writing, modifying, and deleting on all databases.
    If you have any other question, please feel free to let us know. If you find any post in the thread is helpful, you could kindly accept it as answer.

    Best Regards,
    Amelia

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.