Which Table Has Role Name Values in Oracle BRM Database (Doc ID 1338306.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Goal

Consider an example:
In Customer Center where the user created Roles with names as IT, Finance, and Sales. After that, the user added user John Tiger to IT, Peter Pan to Finance, and Henry Joe to Sales.

From the technical point of view (database), how to relate Peter Pan to Finance, John Tiger to IT, and Henry Joe to Sales?
What columns or fields hold the desired output for Roles?

The below query does not relate to the roles:

select c.COMPANY, c.CITY, c.FIRST_NAME, c.LAST_NAME, b.LOGIN
from ACCOUNT_T a, SERVICE_T b, ACCOUNT_NAMEINFO_T c
where a.poid_id0 = b.account_obj_id0 and a.poid_id0 = c.obj_id0 and b.poid_type = '/service/admin_client' ;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.