Is there a way to log into sqlplus without the
username and password available to anyone who wants to grab it?
]
Sent by: cc:
[EMAIL PROTECTED] Subject: how to hide oracle password
from a unix ps -ef | grep?
ity.com
Create a dummy user dummy with pw as dummy and only with create session
priv. Execute a sql script which will connect to the username/pw and
which does
not have read privs at os level for others.
May be someone on the list has a better idea.
HTH
GovindanK
On Fri, 16 Jan 2004 10:04:35 -0800,
Ryan wrote:
Is there a way to log into sqlplus without the username and password
available to anyone who wants to grab it?
Try
http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066,
--
Bricklen Anderson, Database Administrator
e him for what he is not, and a sense of humor was
provided to console him for what he is." --Unknown
-Original Message-From: Ryan
[mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:05
PMTo: Multiple recipients of list ORACLE-LSubject: how
to hide oracle password f
recipients of list ORACLE-LSubject: how
to hide oracle password from a unix ps -ef | grep?
Is there a way to log into sqlplus without the
username and password available to anyone who wants to grab it?
.
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Friday, January 16, 2004 8:04
PM
Subject: how to hide oracle password from
a unix ps -ef | grep?
Is there a way to log into sqlplus without the
username and password available
to hide oracle password from
a unix ps -ef | grep?
Is there a way to log into sqlplus without the
username and password available to anyone who wants to grab it?
Google for hide.c
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
On 01/16/2004 01:34:45 PM, Tanel Poder wrote:
Few ideas:
1) sqlplus /nolog
connect user/[EMAIL PROTECTED]
This requres putting ASCII (non-encrypted) password in the SQL script.
Not very safe.
2) . $HOME/.orapwd
sqlplus user/[EMAIL PROTECTED]
This will actually show password
2) . $HOME/.orapwd
sqlplus user/[EMAIL PROTECTED]
This will actually show password because shell will interpret the ORAPWD
variable before passing the arguments to fork/exec combination. Password
will be clearly visible by ps -ef.
Yep, you're right... I missed this somehow...
Thanks,
line, the
password)
Tanel.
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Friday, January 16, 2004 8:04
PM
Subject: how to hide oracle password
from a unix ps -ef | grep?
Is there a way
12 matches
Mail list logo