Get the DB Owner through T-SQL

Question

Get the DB Owner through T-SQL

SqlUser-529296

SSCarpal Tunnel

Points: 4072
More actions
June 3, 2009 at 1:04 am

#155775

Hi All,
Is it possible to get who is created a database through T-SQL?
For Ex, if i see the Properties of a database there is a column called owner (who is created the database).
Likewise, through T-SQL is it possible to achieve the same owner?
Appreciate your help!!!
---

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

sqluser (6/3/2009)
Hi All,
Is it possible to get who is created a database through T-SQL?
For Ex, if i see the Properties of a database there is a column called owner (who is created the database).
Likewise, through T-SQL is it possible to achieve the same owner?
Appreciate your help!!!
---

You can get the owner of the database by running sp_helpdb. But the owner is not necessarily the user who created the database. In fact on most of the databases I work with, we change the owner to sa.

[font="Verdana"]Markus Bohse[/font]

SqlUser-529296 SSCarpal Tunnel Points: 4072 More actions · Answer 2

Thanks you very much MarkusB for your quick info. 🙂

SqlUser-529296 SSCarpal Tunnel Points: 4072 More actions · Answer 3

MarkusB,

Is it possible to achieve this through sql statement? Like sys.databases some thing like ....

---

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 4

sqluser (6/3/2009)
MarkusB,
Is it possible to achieve this through sql statement? Like sys.databases some thing like ....
---

Is what possible?

[font="Verdana"]Markus Bohse[/font]

george sibbald SSC Guru Points: 104210 More actions · Answer 5

This gives the owner of the database

select suser_sname(sid),name from master..sysdatabases

just add the relevant where clause for a particular database

Retrieving who originally created the database (if different) I dont think can be done. If the owner has never been changed the above query will return the id the person who created the database was logged on with.

---------------------------------------------------------------------

SqlUser-529296 SSCarpal Tunnel Points: 4072 More actions · Answer 6

george sibbald (6/3/2009)
This gives the owner of the database
select suser_sname(sid),name from master..sysdatabases
just add the relevant where clause for a particular database
Retrieving who originally created the database (if different) I dont think can be done. If the owner has never been changed the above query will return the id the person who created the database was logged on with.

Thanks george... Very valuable information as per me.

Thanks...

---

dkamalkumardba SSC Enthusiast Points: 114 More actions · Answer 7

dkamalkumardba

SSC Enthusiast

Points: 114

December 27, 2013 at 1:27 am

#1676045

SELECT suser_sname( owner_sid ), * FROM sys.databases