From JTESTA@longaberger.com Tue, 14 Aug 2001 11:47:30 -0700 From: "JOE TESTA" Date: Tue, 14 Aug 2001 11:47:30 -0700 Subject: RE: New (sort of) Oracle parameters Message-ID: MIME-Version: 1.0 Content-Type: text/plain absolutely, just tried it   create user testuser identified by xx; grant create session, select any table to testuser; connect testuser/xx select password from sys.link$;   shows it all.   joe   >>> rlsmith@kmg.com 08/14/01 03:27PM >>>If what I have read is true then you are telling me that anyone withselect_any_table permissions can read your sys.link$ view and get the useridand passwords for any database links.  Also, the passwords are not encryptedwhen using database links.  The ORA_ENCRYPT_LOGIN is a client parameter thatsays to send the password encrypted.Ron-----Original Message-----Sent: Tuesday, August 14, 2001 12:18 PMTo: Multiple recipients of list ORACLE-LRon,Hp_UX 11.0.32   Database 8.1.6.2We are running with following settings for couple of months without having any problem. No 1. parameter default is TRUE...1- O7_DICTIONARY_ACCESSIBILITY    TRUE2- dblink_encrypt_login           FALSE3- ORA_ENCRYPT_LOGIN   -Not found in v$parameters....MOHAMMAD RAFIQReply-To: ORACLE-L@fatcity.comTo: Multiple recipients of list ORACLE-L Date: Tue, 14 Aug 2001 06:25:23 -0800Is anyone using any of the folowing Oracle parameters?  Are there anyproblems associated with using them?07_DICTIONARY_ACCESSIBILITYDBLINK_ENCRYPT_LOGINORA_ENCRYPT_LOGINRon SmithDatabase Administratorrlsmith@kmg.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Smith, Ron L.   INET: rlsmith@kmg.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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@hotmail.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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@kmg.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).