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_at_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_at_fatcity.comTo: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>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_at_kmg.com--Please see the
official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author: Smith,
Ron L. INET: rlsmith_at_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_at_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 <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
Mohammad Rafiq INET: rafiq9857_at_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_at_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_at_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_at_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).
Received on Tue Aug 14 2001 - 13:47:30 CDT
