Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » authentication required window pl/sql
authentication required window pl/sql [message #330466] Mon, 30 June 2008 04:16 Go to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
Hi,

I need your help for something.
I have a web application, made in pl/sql and I want to login without authentication required window.

How can i connect to this application, using an generic user and password and not introduce every time this user?

Thanks,
chiky

Re: authentication required window pl/sql [message #330479 is a reply to message #330466] Mon, 30 June 2008 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Hard coded it in your program but is is not a good practice.
- Make your program find it in a safe, for instance Oracle Secure password store.

Regards
Michel
Re: authentication required window pl/sql [message #330483 is a reply to message #330479] Mon, 30 June 2008 04:57 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
This window, authentication required had an oracle procedure?
I don't know what procedure to call with this generic user.

i want to hard code, but after i initialize the user and password what procedure to call?

Thanks,
chiky
Re: authentication required window pl/sql [message #330487 is a reply to message #330483] Mon, 30 June 2008 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
connect?
It is not a procedure, it is a statement.

Regards
Michel
Re: authentication required window pl/sql [message #330488 is a reply to message #330487] Mon, 30 June 2008 05:03 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
you can give me more details.

chiky

Re: authentication required window pl/sql [message #330497 is a reply to message #330487] Mon, 30 June 2008 05:17 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
In application is used owa_sec.get_user_id to return the user, but i don't know how this is initialize.

Thanks,
chiky
Re: authentication required window pl/sql [message #330499 is a reply to message #330497] Mon, 30 June 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which kind of application are you using? Forms?

Regards
Michel
Re: authentication required window pl/sql [message #330501 is a reply to message #330499] Mon, 30 June 2008 05:26 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
no, is not Oracle Forms, it is a web application.
The application consists of a pl/sql cartridge. The cartridge invokes the stored procedure.

thanks,chiky


Re: authentication required window pl/sql [message #330558 is a reply to message #330501] Mon, 30 June 2008 07:53 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Hi chiky,
As far as i understand, you don't want auto authorization in your plsql cartridge.
You want to supply username and password at the time of plsql
cartridge page/application render.

Actually your DAD is authorized to 'oracle user name'.
Solution is to deauthorize it. In that case it will
prompt for oracle username and password.

gopal

[Updated on: Mon, 30 June 2008 07:55]

Report message to a moderator

Re: authentication required window pl/sql [message #330581 is a reply to message #330558] Mon, 30 June 2008 09:16 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
Hi,

"Solution is to deauthorize it" - how can i deauthorize, only when i want to connect with this generic user.

Thanks,
chiky
Re: authentication required window pl/sql [message #330732 is a reply to message #330581] Tue, 01 July 2008 01:11 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Use SYS schema to run Deauthorize statement.

BEGIN
  DBMS_EPG.deauthorize_dad (dad_name => '<your DAD name>');
END;
Re: authentication required window pl/sql [message #330767 is a reply to message #330732] Tue, 01 July 2008 02:58 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member
Thanks..

I have another questions.
It will be done a new application in Java and this application will call my web application using: http://server_name/database_name.
When they call this link, the authentication required window to not appear, to be write in Java application the user and to connect automatically to my application.

How can I do this?
Thanks,
chiky
Re: authentication required window pl/sql [message #330776 is a reply to message #330732] Tue, 01 July 2008 03:41 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member

i want also to know, if i can initialize owa_sec.get_user_id in java application.

I can initialize it in another part, not only when I connect using authentication required window?

thanks
chiky
Re: authentication required window pl/sql [message #330779 is a reply to message #330732] Tue, 01 July 2008 03:49 Go to previous messageGo to next message
chiky
Messages: 9
Registered: June 2008
Junior Member

i want also to know, if i can initialize owa_sec.get_user_id in java application.

I can initialize it in another part, not only when I connect using authentication required window?

thanks
chiky
Re: authentication required window pl/sql [message #330782 is a reply to message #330779] Tue, 01 July 2008 04:03 Go to previous message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

first of all owa_sec.get_user_id is function which is only reading information
from DB and returning back to plsql code after authentication. somehow this
particular prob is not related/not having solution with owa_sec.get_user_id.

try some logic with dynamic authorize or deauthorize. In this specific
scenario you can only do one thing. Create 2 separate dads. One is authorized
another is not authorized. Use one for your application and use other
authorized DAD for your java program call.

Gopal
Previous Topic: Retrieve user ID from the current Oracle session
Next Topic: Decrypt PDF file
Goto Forum:
  


Current Time: Thu Mar 28 19:14:35 CDT 2024