Re: Password file timestamp

We do not execute those commands. It still has changes to the files. This happens with most prodcution databases. I realize that password file has information about sysdba users, entries and the password.

On Mon, Jul 20, 2009 at 7:34 PM, Jared Still <jkstill_at_gmail.com> wrote:

> GRANT|REVOKE SYSDBA|SYSOPER to <USER> would do it.
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
> On Mon, Jul 20, 2009 at 4:47 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
>>
>> Listers,
>>
>> We have auditing enabled via a third party software and one of the things
>> they are auditing is $OH/dbs/passwordfiles. The password files seem to get
>> updated and it shows up in the audit reports.
>>
>> I am trying to research on what is causing it, but have been unsuccessful.
>> I came across this one, which does not seem to answer the question:
>> http://asktom.oracle.com/pls/asktom/f/f?p=100:11:0::::P11_QUESTION_ID:2318668671089
>> .
>> I tried creating a test user and locking and unlocking that user, but the
>> password file timestamp did not change in the test case. I tried a user with
>> DBA privs, that did not change it either.
>>
>> Anyone knows what causes the update of the password files when we dont
>> change the passwords.
>>
>> Version is 10.2.
>>
>> Ram.
>>
>>
>
>

--
http://www.freelists.org/webpage/oracle-l