Search code examples
sqlsql-serverprivileges

Query to identify who can make changes to SQL DB objects


I am looking for a query to run on SQL server to identify who can change DB objects structure (DLL) within a SQL server. Please help. Thank you.


Solution

  • Thanks for efforts. I found the following site which gives you multiple queries determining effective database engine permissions.

    https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/determining-effective-database-engine-permissions?view=sql-server-2017