Re: HELP : how to validate Oracle user/pwd _at_ V7

Keith Taylor (keith_at_northlnd.demon.co.uk) wrote:
>First sorry if this has been answered before but I have not been able to
>follow this newsgroup in detail due to lack of time.
>I am trying to convert a shell script which works at release 6 into one
>that works at release 7.2. The release 6 script sets a variable
>SYSTEM_PASS to a supplied Oracle username and password and then calls
>an Oracle module (?) USERCHECK to see if the combination is valid.
>At release 7 this module does not exist, so the question is how can I
>make the same validation for my shellscript at version 7.2 ?

Not sure it's available on all platforms, but 'oiconnect' does what you want on most if not all.

/b

--
Bill Manry  -  Mainframe and Integration Technologies  -  Oracle Corporation
Standard disclaimer applies.