RE: New (sort of) Oracle parameters

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 14 Aug 2001 11:18:51 -0700
Message-ID: <F001.0036A3F7.20010814112738@fatcity.com>

If what I have read is true then you are telling me that anyone with select_any_table permissions can read your sys.link$ view and get the userid and passwords for any database links. Also, the passwords are not encrypted when using database links. The ORA_ENCRYPT_LOGIN is a client parameter that says to send the password encrypted.

Ron

-----Original Message-----

Sent: Tuesday, August 14, 2001 12:18 PM
To: Multiple recipients of list ORACLE-L

Ron,

Hp_UX 11.0.32 Database 8.1.6.2

We are running with following settings for couple of months without having any problem. No 1. parameter default is TRUE... 1- O7_DICTIONARY_ACCESSIBILITY TRUE 2- dblink_encrypt_login FALSE

3- ORA_ENCRYPT_LOGIN -Not found in v$parameters....

MOHAMMAD RAFIQ Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 14 Aug 2001 06:25:23 -0800

Is anyone using any of the folowing Oracle parameters? Are there any problems associated with using them?

07_DICTIONARY_ACCESSIBILITY DBLINK_ENCRYPT_LOGIN ORA_ENCRYPT_LOGIN Ron Smith
Database Administrator
rlsmith_at_kmg.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.

   INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 14 2001 - 13:18:51 CDT