Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: New (sort of) Oracle parameters
I am trying to get sql*net to trace my connection to the database from my desktop. Oracle says I can set trace_level_client to 16 and I will see the userid and password in the trace file. I tried it but I don't get either one. I get a lot of other stuff in the trace file but no userid or password. Anyone tried this?
Ron
-----Original Message-----
Sent: Tuesday, August 14, 2001 1:55 PM
To: ORACLE-L_at_fatcity.com; rlsmith_at_kmg.com
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 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
<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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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 - 14:26:40 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |