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: How to find out concrete ORACLE_HOME via SQL?

Re: How to find out concrete ORACLE_HOME via SQL?

From: NitelyJoy <nitelyjoy_at_ist-einmalig.de>
Date: 14 Aug 2006 12:52:58 -0700
Message-ID: <1155585178.683829.285760@m79g2000cwm.googlegroups.com>


Getting back to the initial question:
Why is there no dictionary view that gives out ORACLE_HOME and/or password file location?

Oracle has no need for "security by obscurity" as mentioned above. Nevertheless, to satisfy the safety-conscious DBAs, oracle could protect it by the SELECT ANY DICTIONARY grant and/or the 07_dictionary_accessibility pfile parameter. IMHO, the advantages (better configuation transparency) outweigh the disadvantages (maybe less security).

Thanks to all of you for participating the discussion. Good luck for your DBA work. Received on Mon Aug 14 2006 - 14:52:58 CDT

Original text of this message

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