Home » RDBMS Server » Security » how to detect which user has changed the password
how to detect which user has changed the password [message #18981] Sun, 24 February 2002 23:18 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
I have a user called test,he has the dba privelages also.

Now suddenly,someone has changed the password for that user.

How can i detect
1) which user has changed the password(may be the person has logged in as the same user name)
2) When was the alter statement issued (with time)
3) From which system,terminal,client system does this request was issued.

How to tract that person as it is becomming a big problem everytime..

Some one is trying to play with the database and we want to catch that person

Any help in this is appreciated...

thanks
ksr
Re: how to detect which user has changed the password [message #18982 is a reply to message #18981] Sun, 24 February 2002 23:31 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
r u using database auditing ? if u r doing so , then u can get these information .
Re: how to detect which user has changed the password [message #18984 is a reply to message #18982] Mon, 25 February 2002 00:30 Go to previous message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
i am not using database auditing.

If i use the database auditing,what is the performance issue as oracle will start writing most of the stuff..
Previous Topic: password for the first time use of PL/SQL Plus, need help.
Next Topic: how do i get what are the roles assigned to a user
Goto Forum:
  


Current Time: Thu May 26 16:18:58 CDT 2022