Find the database owner name from the owner_sid - t-sql and suser_sname

Finding the owner name from the sys.databases catalog view  owner_sid column is simple . Sys.databases returns all the databases on the SQL Server Instance , one of the columns is owner_sid – which returns a  varbinary(85) column.  A example is 0x010500000000000515000000323AF1A8V4034CF686BFA5EE0C460000

The owner_sid returns the security identifier of the database. From the sid it is difficult to derive the owner name. Using suser_sname returns the owner name

--for all databases
select suser_sname(owner_sid) as 'owner_name', name from sys.databases

--single database
select suser_sname(owner_sid) as 'owner_name', name from sys.databases where name = DB_NAME

 Read More on current user and security policy

 SQL Server – Find current user and sysadmin - SQL Server DBA

SQL Server Security Policy - SQL Server DBA

Powershell sql server security audit - SQL Server DBA