Re: Remote login password file questions.

Thanks Howard,
I confess that I have not read ALL of the Oracle documentation, but I have read the 9i Concepts and various other books. I have never seen "writing/updating to the password file" documented as part of the server process function. I wonder why this functionality is mostly undocumented. It seems rather important to me.

The fact that the server process does some updating also begs the question - what about recovery?
What happens if you recover the database to a point in time prior to the password file update?
Will SMON update the password file?

If you can direct me to any documentation that contains this level of detail, I would love to read it.

Howard, if you choose to answer, please reply to the group so that everybody can benefit.
Regards,
Mike

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f764f67$0$14559$afc38c87_at_news.optusnet.com.au...
> Michael J. Moore wrote:
>
> > Assume REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE.
> > A DBA issues "grant sysdba to mike;".
> > So, question #1 is: What process updates the password file? DBWR? SMON?
> > PMON? etc, Which one?
>
> The server process of the person issuing the grant SQL statement.
>
> As is ever the case: if you ask for something, be it data from EMP, to
> update a salary column, or to modify the password file, it's your server
> process that does your bidding.
>
> Regards
> HJR
Received on Sun Sep 28 2003 - 10:25:11 CDT