Password Verification without Logging in

[papalpha]

I have a student using a form and entering information. I have in instructor looking over his/her shoulder. When the instructor is satisfied with the student’s work, he/she is to enter his/her username and password to approve it to the system. Is there a way in forms or PL/SQL that I can verify that the username & password are valid for the instance without them actually logging in? I know I can verify the username against DBA_USERS, but the password is encrypted and the typed in will not compare with it.

 

[lewisp]

If you want to compare against the current username and password you can read them using GET_APPLICATION_PROPERTY.

 

[papalpha]

No, I do not want to compare against the current user. The instructor will not be logged in, just grading the work and proving who he/she is before it accepts the grade.

 

[sem]

You may create instructor's session using EXEC_SQL.OPEN_CONNECTION built-in. Don't forget to close it.

Regards, Dima

http://seminihin.narod.ru

 

[papalpha]

I don't want the instructor to actually create another session or even log in. I just want to verify that his username and password are valid, then return to the students screen so he/she can continue.

 

[sem]

Another option is to create dblink using instructors username/password and make an attempt to get some data from it. In any case without creating a new session you can not check a password.

Regards, Dima

http://seminihin.narod.ru

 

[papalpha]

I tried that, it let me create a link with a valid userid and invalid password. It must not check until the dlink is actually used.
Thanks for trying to help.

 

[sem]

Read it again, I suggested to "make an attempt to get some data from it"

Regards, Dima

http://seminihin.narod.ru