Home » RDBMS Server » Server Administration » details
details [message #242737] Mon, 04 June 2007 23:19 Go to next message
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: 4516
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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: Help required with ORA - 28000 Error
Next Topic: ASM : diskgroup creation error
Goto Forum:

Current Time: Sun Aug 20 16:10:21 CDT 2017

Total time taken to generate the page: 0.09227 seconds