I would like to use "Proxy Authentication"[1] in Oracle Database Express Edition. My goal is to connect to database and work on behalf of other user without knowing his password.
My ideal solution is:
ALTER USER bill GRANT CONNECT THROUGH appserve;
then my app could connect as:
appserve[bill]/password@demo.world
Unfortunately table "Comparisons"[2] says "Proxy Authentication" is not available in Express edition.
Above solution works on my installation of XE. I do not see anything about that in "Licensing Information - Oracle Database Editions"[3] nor "Licensing Information - Options and Packs"[4] (including "Feature Availability for Oracle Database Editions").
Is it legal to use that feature in XE version of Oracle Database?
Maybe express edition just do not support more advanced solution(ex. kerberos)?
Links:
1. http://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90117/users.htm#15149
2. http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html
3. http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109
4. http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC139