Home » RDBMS Server » Security » Who created the database users
Who created the database users [message #231466] Tue, 17 April 2007 03:41 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Hi,

There are a lot of users in our database. I would like to know who created each of these users? eg. sys, abc, system ....

Is this possible?

Thank you.
Re: Who created the database users [message #231473 is a reply to message #231466] Tue, 17 April 2007 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless you audited the CREATE USER statement.

Regards
Michel
Re: Who created the database users [message #269823 is a reply to message #231466] Mon, 24 September 2007 14:57 Go to previous message
parthokonar
Messages: 17
Registered: September 2006
Location: india
Junior Member
Yes Michel is true and if the database is been created by DBCA some users are by default is created. You can check every thing from DBA_USERS but if you want to see who created these you have to go for auditing.
Previous Topic: Regarding password file authentication
Next Topic: decrypting password
Goto Forum:
  


Current Time: Sun Apr 20 08:55:56 CDT 2014

Total time taken to generate the page: 0.06415 seconds