OraFAQ Forum: Server Administration » How to find out Database Owner in Oracle?

Home » RDBMS Server » Server Administration » How to find out Database Owner in Oracle? (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find out Database Owner in Oracle? [message #664427]

Mon, 17 July 2017 07:03

muniraj_tomar
Messages: 7
Registered: July 2017

Junior Member

Hi all , is there any query to find out the Database Owner(who has created the database) name?

Currently we are trying with below query

SELECT host_name FROM v$instance

Is there any other way to find the Owner. please reply.

Report message to a moderator

Re: How to find out Database Owner in Oracle? [message #664429 is a reply to message #664427]

Mon, 17 July 2017 07:07

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

muniraj_tomar wrote on Mon, 17 July 2017 05:03

Hi all , is there any query to find out the Database Owner(who has created the database) name?

Currently we are trying with below query

SELECT host_name FROM v$instance

Is there any other way to find the Owner. please reply.

database owner is OS user who owns the files.

Report message to a moderator

Re: How to find out Database Owner in Oracle? [message #664432 is a reply to message #664429]

Mon, 17 July 2017 07:21

muniraj_tomar
Messages: 7
Registered: July 2017

Junior Member

ok, if we are creating multiple instances then owner would be same ? or it would be the one which we will give at the time of database creation?

Report message to a moderator

Re: How to find out Database Owner in Oracle? [message #664433 is a reply to message #664432]

Mon, 17 July 2017 07:27

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

muniraj_tomar wrote on Mon, 17 July 2017 05:21

it would be the one which we will give at the time of database creation?

HUH? No username is given or required to create new Oracle database.
SYS schema always owns DB metadata objects.

What business problem are you trying to solve?
What will you do different after this question has been answered?

Report message to a moderator

Re: How to find out Database Owner in Oracle? [message #664437 is a reply to message #664432]

Mon, 17 July 2017 09:37

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

muniraj_tomar wrote on Mon, 17 July 2017 14:21

ok, if we are creating multiple instances then owner would be same ? or it would be the one which we will give at the time of database creation?

Instance owner is the one that starts it, it is not necessary the same one for all instances of a database.
Database owner is the one that owns the database files.

Report message to a moderator

Previous Topic:	Unable to connect to Oracle DB (11g R2)
Next Topic:	Is there any way to find out if a database is a copy of another database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 18 18:05:26 CST 2021