Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Remote login password file questions.

Re: Remote login password file questions.

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 28 Sep 2003 12:59:50 +1000
Message-ID: <3f764f67$0$14559$afc38c87@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 Sat Sep 27 2003 - 21:59:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US