RE: New (sort of) Oracle parameters

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 14 Aug 2001 12:26:40 -0700
Message-ID: <F001.0036A629.20010814124148@fatcity.com>

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 Lists


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

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

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

--

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 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 <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

--

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