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: 4509
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: 64961
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 : Free Space and Allocated space growth difference
Next Topic: Listener Problem
Goto Forum:

Current Time: Tue Jun 27 16:03:29 CDT 2017

Total time taken to generate the page: 0.09272 seconds