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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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: Wed Dec 04 13:50:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.