This content has been marked as final. Show 8 replies
Oracle Portal users are not defined in the database. They are defined as entries in your LDAP server (Oracle Internet Directory) below the tree defined as Users Search Base in Oracle Portal :
Portal Builder > Administration > Global Settings > Tab: SSO/OID
As such, there is no mapping between the users defined in Oracle Internet Directory and the users defined in your database.
To connect to the database, Oracle Portal uses Proxy Authentication (http://docs.oracle.com/cd/B28359_01/java.111/b31224/proxya.htm). Connections are made predominantly by the user PORTAL_PUBLIC (which is often mentioned in the Database Schema setting in the user's properties). The database schema in the Portal User Profile defines the schema which is used to execute the procedures in the Portal metadata repository database. Theoretically you could use a different schema than Oracle Portal but I have not seen any cases where this was useful.
Thank you for your quick response Erik.
I reviewed the Proxy Authentication chapter and have an additional question.
A number of records are returned after I execute SELECT * FROM proxy_users. The client column lists schemas I created to assign to portal lightweight users under their user profile. Each schema (client) is assigned different roles to give them restricted access to execute certain packages. These packages execute html pages using mod_plsql.
New Question: Which table can I query to determine which lightweight users are assigned to which schemas (clients)?
Thank you for your continued assistance:
That should be available in PORTAL.WWSEC_PERSON$ :
As you can see, I have changed the Database Schema for user JOHN.DOE to INTRANET_CORE temporarily in the UI, which indeed got reflected in the table wwsec_person$.
select user_name, db_user from wwsec_person$ USER_NAME DB_USER ------------------------- ------------------------------ JANE.DOE DEV_PORTAL_PUBLIC JOHN.DOE INTRANET_CORE DEV_PORTAL DEV_PORTAL_PUBLIC PUBLIC DEV_PORTAL_PUBLIC ORCLADMIN DEV_PORTAL_PUBLIC TEST2 DEV_PORTAL_PUBLIC MY_PORTAL_ADMIN DEV_PORTAL_PUBLIC
Thank you Erik.
I just executed:
select user_name, proxy, client
where client = db_user;
This gave me the information I was interested in obtaining.
Do you have familiarity with APEX? I know this is the wrong forum, but I'm trying to determine if there is a way to implement Proxy Authentication or something that would give me the same result in APEX.
If this is out of your area, I'll close this thread and open up a new one in the APEX forum.
The official statement of direction for Oracle Portal wouldn't let you think so. The document is from 2009 however. Oracle Portal 11g contained some new features. Reality is however that the majority of the new features will be delivered through the WebCenter Portal product which is Oracle's strategic Portal product.