| how do i track the user who is changing the password [message #50030] |
Sun, 24 February 2002 23:25  |
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 do i track the user who is changing the password [message #50037 is a reply to message #50030] |
Mon, 25 February 2002 04:56  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
You could turn auditing on (the only way to log these actions) but if TEST has DBA they can delete the records from $AUD. I would suggest taking away DBA from TEST and turning auditing on. Change the password to TEST and make all users come to you for the password and have them sign something saying they will not change/give out the password or action will be taken up to termination. You are the only one that can take control. Also change the password to ALL DBA accounts and do not give the password out.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
