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.

Report message to a moderator

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: 54142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless you audited the CREATE USER statement.

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Regarding password file authentication
Next Topic: decrypting password
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 10:37:08 CDT 2013

Total time taken to generate the page: 0.07321 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.