-
batch sql programs
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,
-
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.
-
hi,
Sorry, I mean the hard coded oracle userid and password,
not the program.
Thanks
-
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
-
on windoze
C:\> set username=scott
C:\> set password=tiger
C:\> sqlplus %username%/%password%@connect_string
on unix
use ops$ authentication.
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
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?
-
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.
Code:
Sqlplus -S /NOLOG @Logon.sql
Logon.sql
=========
Connect User_name/Pswd@String
@c:\mis\prg\clean_up.sql
exit
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|