Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Running file sql from shell without capture the password

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Running file sql from shell without capture the password
# 1  
Old 08-31-2006
Running file sql from shell without capture the password
Dear All

I have file a.sql, let's say the content is:
_________________________________
select * from dual;
exit;
_________________________________
and I have shell script a.sh, the content is:
_________________________________
ORACLE_SID=testing; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus user_name/password @a.sql
_________________________________

when I run ./a.sh then in the other window I run:
_________________________________
while true
do
ps -ef|grep more
done
_________________________________
I will get the information that the user_name=user_name and the password=password

To solve this, I move user_name/password to a.sql using connect user_name/password in the very beginning and use sqlplus /nolog @a.sql in a.sh.

What I want to know is there any other way to put my password and user name in a.sh, but people can't get my password and user name.

Thx in advance

Regards,
Aditya Purwanto
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

2. Solaris

Primary key issue when running Oracle sql file

I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem? its got me spinning, thanks. REM REM List of... (1 Reply)
Discussion started by: Wpgn
1 Replies

3. Shell Programming and Scripting

Capture rows for a column in file from delete sql -Oracle

Hi, This may not be the right forum but i am hoping someone knows an answer to this. I have to capture rows for a column that was deleted. How can i do that without having to write a select query? delete from myschema.mytable where currentdatetimestamp > columnDate this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies

4. Shell Programming and Scripting

Running Oracle SQL from shell script

Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file. #!/bin/sh # A menu driven Shell script which has following options # for acmtoron@> # # # Exit # As per option do the job #---- while : do clear echo " A C M LOG MONITORING... (0 Replies)
Discussion started by: tinaaguilera
0 Replies

5. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

6. Shell Programming and Scripting

How to stop asking password while running shell script?

Hello, I am ftping the file from one unix box to another box. This script works fine. Only problem here is, it is asking the password when ftp the file. How can i stop that. I am providing the password inside the shell script. But it is not accepting this. I need to put this script in crontab.... (5 Replies)
Discussion started by: govindts
5 Replies

7. Shell Programming and Scripting

How to capture value in shell variable from oracle sql?

Hi Friends, Do someone know how to capture value in a shell variable from oracle sql? Requirement : In a table we want to count the number of records and want to pass this value to a shell variable where it can be manipulated later. In ksh shell we open oracle connection from sqlplus. For... (1 Reply)
Discussion started by: sourabhsharma
1 Replies

8. AIX

How transfer sql file from one serverto another without username and password

hi there, Please help me How transfer sql file from one server to another without username and password .i know just IP address. Thanks Arpit (1 Reply)
Discussion started by: Arpitmitm
1 Replies

9. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

I've a script that fetches various values from the database as below: #! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further... (6 Replies)
Discussion started by: manthasirisha
6 Replies

10. Shell Programming and Scripting

Running remote shell script containing sql statements

I have a shell script which resides on three SCO machines containing some simple sqlplus statments. I need to run these scripts remotely. Currently, I am trying to use rsh to do so: rsh hostname myscript args The problem is that the arguments to the sqlplus statements in the remote shell... (4 Replies)
Discussion started by: Madbreaks
4 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

git-annex-shell

git-annex-shell(1)					      General Commands Manual						git-annex-shell(1)

NAME

       git-annex-shell - Restricted login shell for git-annex only SSH access

SYNOPSIS

       git-annex-shell [-c] command [params ...]

DESCRIPTION

       git-annex-shell is a restricted shell, similar to git-shell, which can be used as a login shell for SSH accounts.

       Since  its  syntax  is  identical to git-shell's, it can be used as a drop-in replacement anywhere git-shell is used. For example it can be
       used as a user's restricted login shell.

COMMANDS

       Any command not listed below is passed through to git-shell.

       Note that the directory parameter should be an absolute path, otherwise it is assumed to be relative to the user's home directory. Also the
       first "/~/" or "/~user/" is expanded to the specified home directory.

       configlist directory
	      This outputs a subset of the git configuration, in the same form as git config --list

       inannex directory [key ...]
	      This checks if all specified keys are present in the annex, and exits zero if so.

       dropkey directory [key ...]
	      This drops the annexed data for the specified keys.

       recvkey directory key
	      This runs rsync in server mode to receive the content of a key, and stores the content in the annex.

       sendkey directory key
	      This runs rsync in server mode to transfer out the content of a key.

       commit directory
	      This commits any staged changes to the git-annex branch.	It also runs the annex-content hook.

OPTIONS

       Most options are the same as in git-annex. The ones specific to git-annex-shell are:

       --uuid=UUID
	      git-annex uses this to specify the UUID of the repository it was expecting git-annex-shell to access, as a sanity check.

HOOK

       After  content is received or dropped from the repository by git-annex-shell, it runs a hook, .git/hooks/annex-content (or hooks/annex-con-
       tent on a bare repository). The hook is not currently passed any information about what changed.

ENVIRONMENT

       GIT_ANNEX_SHELL_READONLY

	      If set, disallows any command that could modify the repository.

       GIT_ANNEX_SHELL_LIMITED
	      If set, disallows running git-shell to handle unknown commands.

SEE ALSO

       git-annex(1)

       git-shell(1)

AUTHOR

       Joey Hess <joey@kitenet.net>

       <http://git-annex.branchable.com/>

																git-annex-shell(1)