Re: SQL security shells

Article View: comp.security.unix

Article #185

Back to comp.security.unix Previous Next

#185

From: S S Wan
Date: Tue, 07 Oct 1997 00:00

71 lines
2943 bytes

This is a multi-part message in MIME format.

------=_NextPart_000_00B5_01BCD351.29018B30
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

In you are using Oracle, you may try OS-authentication.
Laurent Deperthes wrote in message =
<3433502A.8BB472BA@pline.ava.tcr.renault.fr>...
    Hello,=20
    how to create a shell script csh tcsh .. for creating a call to sql =
request=20
    eg=20
   =20
    #!/bin/csh=20
    sqlplus user/pass @script.sql=20
   =20
    the problem is that all users see the user ans the pass  also in ps =
-eaf  and w commands=20
   =20
    shells must have r-x protection to start so you see all of these =
informations ..=20
     =20
   =20
    thanks for answers ...
        mailto:Laurent.Deperthes@renault.com
     =20

------=_NextPart_000_00B5_01BCD351.29018B30
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>In you are using Oracle, you may try=20
OS-authentication.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: =
5px">
    <DIV>Laurent Deperthes<DEPERTLA@PLINE.AVA.TCR.RENAULT.FR> wrote in =
message=20
    &lt;<A=20
    =
href=3D"mailto:3433502A.8BB472BA@pline.ava.tcr.renault.fr">3433502A.8BB47=
2BA@pline.ava.tcr.renault.fr</A>&gt;...</DIV>Hello,=20
   =20
    <P>how to create a shell script csh tcsh .. for creating a call to =
sql=20
    request <BR>eg=20
    <P>#!/bin/csh <BR>sqlplus user/pass @script.sql=20
    <P>the problem is that all users see the user ans the pass&nbsp; =
also in ps=20
    -eaf&nbsp; and w commands=20
    <P>shells must have r-x protection to start so you see all of these=20
    informations .. <BR>&nbsp; <PRE>thanks for answers =
...</PRE><PRE>&nbsp;&nbsp;&nbsp; <A =
href=3D"mailto:Laurent.Deperthes@renault.com">mailto:Laurent.Deperthes@re=
nault.com</A></PRE>&nbsp;=20
    </BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_00B5_01BCD351.29018B30--

Technical Details

Message-ID: <61d3kg$2qr$1@tst.hk.super.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3433502A.8BB472BA@pline.ava.tcr.renault.fr>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10952f,7a50d346c65d2139
X-Google-Attributes: gid10952f,public
X-Google-Thread: 110f2c,7a50d346c65d2139
X-Google-Attributes: gid110f2c,public
X-Google-Thread: 1012a6,7a50d346c65d2139
X-Google-Attributes: gid1012a6,public
From: "S S Wan" <sswan@hk.super.net>
Subject: Re: SQL security shells
Date: 1997/10/07
Message-ID: <61d3kg$2qr$1@tst.hk.super.net>
X-Deja-AN: 279040389
References: <3433502A.8BB472BA@pline.ava.tcr.renault.fr>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Hong Kong Supernet
Newsgroups: comp.security.unix,comp.unix.shell,fr.comp.os.unix

Reply to Parent Message