Authentication without logging in?

From: fabio <faneas_at_gmail.com>
Date: 6 Oct 2006 15:14:53 -0700
Message-ID: <1160172893.910073.113370@e3g2000cwe.googlegroups.com>

Hi folks,
I've been told that it is possible to authenticate an Oracle User using another session. To cut a very long story short, please have a look at the case bellow:

User A (actually, a middleware) is logged in, and wants to execute a function such as DBMS_SOMETHING.AUTHENTICATE_USER ('USER_B', 'USER_B''S PASSWORD') The function would return true if USER_B exists in the database and the password is correct.

>From what I know, the only way to achieve this by connecting. Can you
refer some doc showing this is NOT possible (well, maybe I'm wrong and there is a way) so I can rest in peace?

Thanks,
Fabio Received on Fri Oct 06 2006 - 17:14:53 CDT