Home » RDBMS Server » Server Administration » details
details [message #242737] Mon, 04 June 2007 23:19 Go to next message
rpakanati
Messages: 1
Registered: June 2007
Junior Member
ravi reddy:
I want to know in sql that how we can knw who is the owner of particular databse??is their any sql query??
Re: details [message #242762 is a reply to message #242737] Tue, 05 June 2007 00:58 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Why do you mean? The DBA is always the owner. If you want to check what users are created within the database, select from DBA_USERS.
Re: details [message #242774 is a reply to message #242737] Tue, 05 June 2007 01:20 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I think you meant "schema" instead of "database".
In Oracle, a user account is also a schema, a schema is also a user account.
The owner of a schema is then the user with the same name as the schema.

Regards
Michel
Previous Topic: Help : Free Space and Allocated space growth difference
Next Topic: Listener Problem
Goto Forum:
  


Current Time: Tue Dec 03 09:15:31 CST 2024