batch sql programs

[kris123]

Hi,

I have a batch file which contains a sqlplus
command:

sqlplus scott/tiger @c:\mis\prg\clean_up.sql

How can I hide passwords on sqlplus batch file
so that users won't be able to see my password?

In unix, whenever you issue ps -ef, it will
display completely the whole command.

Do I have to convert my sqlplus programs to be
able to secure it.

Thanks,

[slimdave]

depending on the contents of the file, you may do better to create a stored procedure to run the required commands, then give execute permission on the procedure to individual users.

[kris123]

hi,

Sorry, I mean the hard coded oracle userid and password,
not the program.

Thanks

[clio_usa]

Use of the many batch file compilers - http://www.bdargo.com/info/batcomp.htm . You will have exe file, which is hard to read from a regular user. Hackers with some efforts will crack it.


Hope that helps,

clio_usa

OCP 8/8i/9i DBA
Visit our Web Site

[adewri]

on windoze

C:\> set username=scott
C:\> set password=tiger
C:\> sqlplus %username%/%password%@connect_string

on unix
use ops$ authentication.

HTH

[slimdave]

Originally posted by kris123
hi,

Sorry, I mean the hard coded oracle userid and password,
not the program.

Thanks

why not give the users their own id's and passwords?

[abhaysk]

Originally posted by kris123
hi,

Sorry, I mean the hard coded oracle userid and password,
not the program.

Thanks

Work around wud be possible, but with an extra SQL file.

Sqlplus -S /NOLOG @Logon.sql

Logon.sql
=========

Connect User_name/Pswd@String

@c:\mis\prg\clean_up.sql 

exit

Abhay.

[hamhey]

Hi,
Unix:
Do like this:
create test.sql put the following sql commands in the file:

connect / as sysdba
..
< any sql commands>
select * from scott.emp;
...
..
exit;

And execute the command by:
sqlplus /nolog @test.sql

In this way you side the useid/password from world. You can run it as crontab.
Remember this is possible only if you are on the
same server.

//hamhey