sqlplus and script writing. 
Author Message
 sqlplus and script writing.
Hi all!
        I have a question about sqlplus scripts. I see many scripts written that
start sqlplus and use a "/" for userid and password. How is this possible?
Is this a security problem?

Thanks again,

Tom



Wed, 18 Jun 1902 08:00:00 GMT
 sqlplus and script writing.

Hi Tom,

This is because the userids were created as 'ops$<os-userid>' userids, which means
that  the operating system validation  i.e. logon is sufficient to log on to Oracle.

- Aziz Rahman

Quote:

> Hi all!
>         I have a question about sqlplus scripts. I see many scripts written that
> start sqlplus and use a "/" for userid and password. How is this possible?
> Is this a security problem?

> Thanks again,

> Tom



Wed, 18 Jun 1902 08:00:00 GMT
 sqlplus and script writing.


Quote:
>    I have a question about sqlplus scripts. I see many scripts written that
>start sqlplus and use a "/" for userid and password. How is this possible?
>Is this a security problem?

This could actually be a good thing in terms of security. I
have several cron jobs that do that. It works because I
created an OPS$ account for the Unix user. The end result is
that I do not need to embed oracle usernames and passwords
in my administrative scripts.

Jonathan

_____________________________________________________

http://gennick.com
Brighten the Corner Where You Are



Wed, 18 Jun 1902 08:00:00 GMT
 sqlplus and script writing.
You should be careful and put the sqlplus in a shell because the ps command
will show the sqlplus <username>/<password> strings.

Cliff



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Writing shell scripts for nt and sqlplus?

2. Problem coming out sqlplus from korn shell script

3. Passing Command Line Parms to Anonymous Procedures in an SQLPLUS script

4. UNIX script problem with sqlplus

5. Trapping errors in SQLPLUS scripts

6. Passwd problem when running sqlplus from shell script

7. shell script with sqlplus call not working in cron

8. Inarguments to a sqlplus script.

9. SQLPLUS script

10. When and where to use .../sqlplus/pupbld.sql script

11. search order for sqlplus scripts


 
Powered by phpBB® Forum Software