Re: SQL security shells

Article View: comp.security.unix

Article #183

Back to comp.security.unix Previous Next

#183

From: Happl Oberlin
Date: Thu, 09 Oct 1997 00:00

32 lines
1473 bytes

Mark Rothstein wrote:
> 
> If you make the user/pass the first line in script.sql, it should do
> the job.
> 
> Laurent Deperthes wrote:
>
>      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
>

It should work like this (at least with bsh or ksh; I'm not familiary
with csh), if user scott/tiger exists:

sqlplus scott/tiger <<EOF
connect user/pass
start script.sql
EOF

Happl
-- 
I have no ideas for my signature. Any suggestions are welcome!
  - - - - - - - - - -
Ich habe keine Idee fuer meine Signatur. Jeder Vorschlag ist willkommen!

Technical Details

Message-ID: <343CE1D8.763B@gmz.migros.ch>

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

References: <3433502A.8BB472BA@pline.ava.tcr.renault.fr> <343BFB7D.2094162A@snet.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
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: Happl Oberlin <hanspeter.oberlin@gmz.migros.ch>
Subject: Re: SQL security shells
Date: 1997/10/09
Message-ID: <343CE1D8.763B@gmz.migros.ch>
X-Deja-AN: 278967258
References: <3433502A.8BB472BA@pline.ava.tcr.renault.fr> <343BFB7D.2094162A@snet.net>
Organization: Migros Zurich/Switzerland
Reply-To: hanspeter.oberlin@gmz.migros.ch
Newsgroups: comp.security.unix,comp.unix.shell,fr.comp.os.unix

Reply to Parent Message