Hi There! Today I am going to provide you with a simple Query To List SQL Database Role Owner. Understanding who owns a role helps database administrators (DBAs) track permissions and audit role management effectively.

Where Do you See the Database Role Owner?

In SSMS (SQL Server Management Studio), Expand the Database > Security > Roles > Database Roles > Right Click on the Role > Properties

Query To List Database Role Owner

Possible Scenarios:

These are few possible cases when you may need to to list out the Database Role Owners.

  • Review current role ownership across multiple databases.
  • Ensure roles are owned by intended users or service accounts.
  • Document security settings for compliance.

Query To List SQL Database Roles and the Owner:

USE SQLGeeksPro 
GO
SELECT Dbname=DB_NAME(DB_ID()),
       name AS RoleName,
       USER_NAME(owning_principal_id) AS RoleOwner
FROM 
       sys.database_principals
WHWRE 
       Type='R'

Example Result Set:

Query to List SQL Database Role Owner

If you want to run the script across all databases in a single SQL Instance refer Query to List SQL Database Role Owner Across All Databases

Please let me know if that helps by leaving your comment below.