🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.security.unix
Article #182

Re: SQL security shells

#182
From: Mark Rothstein
Date: Wed, 08 Oct 1997 00:00
82 lines
2301 bytes

--------------309FD7F0489C33E3A8E48BE2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

If you make the user/pass the first line in script.sql, it should do the
job.

Laurent Deperthes wrote:

>
>
> Hello,
>
> how to create a shell script csh tcsh .. for creating a call to sql
> request
> eg
>
> #!/bin/csh
> sqlplus user/pass @script.sql
>
> the problem is that all users see the user ans the pass  also in ps
> -eaf  and w commands
>
> shells must have r-x protection to start so you see all of these
> informations ..
>
>
> thanks for answers ...
>
>     mailto:Laurent.Deperthes@renault.com
>
>



--

Mark Rothstein
markr@snet.net


--------------309FD7F0489C33E3A8E48BE2
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
If you make the user/pass the first line in script.sql, it should do the
job.

<P>Laurent Deperthes wrote:
<BLOCKQUOTE TYPE=CITE>&nbsp;

<P>Hello,

<P>how to create a shell script csh tcsh .. for creating a call to sql
request
<BR>eg

<P>#!/bin/csh
<BR>sqlplus user/pass @script.sql

<P>the problem is that all users see the user ans the pass&nbsp; also in
ps -eaf&nbsp; and w commands

<P>shells must have r-x protection to start so you see all of these informations
..
<BR>&nbsp;
<PRE>thanks for answers ...</PRE>

<PRE>&nbsp;&nbsp;&nbsp; <A HREF="mailto:Laurent.Deperthes@renault.com">mailto:Laurent.Deperthes@renault.com</A></PRE>
&nbsp;</BLOCKQUOTE>
&nbsp;

<P>--

<P>Mark Rothstein
<BR>markr@snet.net
<BR>&nbsp;</HTML>

--------------309FD7F0489C33E3A8E48BE2--
Technical Details
Message-ID: <343BFB7D.2094162A@snet.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: 1012a6,7a50d346c65d2139
X-Google-Attributes: gid1012a6,public
X-Google-Thread: 110f2c,7a50d346c65d2139
X-Google-Attributes: gid110f2c,public
From: Mark Rothstein <markr@snet.net>
Subject: Re: SQL security shells
Date: 1997/10/08
Message-ID: <343BFB7D.2094162A@snet.net>
X-Deja-AN: 278959500
References: <3433502A.8BB472BA@pline.ava.tcr.renault.fr>
X-Priority: 3 (Normal)
To: Laurent.Deperthes@renault.com
Organization: "SNET dial access service"
Newsgroups: comp.security.unix,comp.unix.shell,fr.comp.os.unix