| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Need to bypass Oracle Web Server Login Screen.
A copy of this was sent to "Steven Liu" <steven_liu_at_bmc.com>
(if that email address didn't require changing)
On Wed, 25 Nov 1998 13:37:52 -0600, you wrote:
>Hi Everyone;
>
>I currently develop a application that need to send URL to Oracle Web server
>to execute PL/SQL procedure.
>If DAD is set to store user name and password, you can send URL to PL/SQL
>Cartridge without user name and password. If DAS is not set to store user
>name and password, when you send URL to PL/SQL Cartridge, Oracle Web server
>will pop up login screen.
>I want to do some thing like batch Process. So if user has password and
>userid, they do not need to type in userid and password. I can schedule to
>run URL at pre define time.
>
>Any idea how to bypass userid and password to run PL/SQL if I have real
>userid and password ? Do you think that Java Cartridge has this kind of
>capability ?
>
>like if you run sqlplus, you can do like this:
>sqlplus userid/password_at_athost.
>
>Any suggest is welcome.
>
>steven Liu
>
>
Well, it depends on WHAT you are using to grab the URL.
You can (in most browsers) pass the username/password in like this:
http://username:password@hostname/foo/owa/owa_util.print_cgi_env ^^^^^^^^ ^^^^^^^^
If you wrote your own, you'll have to base64 encode the usename and password and stuff it into the HTTP request itself as one of the header records.
If you are using ICX and writing a cartridge, there are apis to do this.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Nov 25 1998 - 14:25:25 CST
 |
 |