Human Capital Management - EBS (MOSC)

MOSC Banner

Query to review access to roles allocated under User Manager

edited Sep 7, 2018 5:44AM in Human Capital Management - EBS (MOSC) 2 commentsAnswered ✓

Hello All.

I am trying to locate tables to pull an extract (via sql) off people who have been allocated roles but cannot locate the current table for this.
People have been allocated Learning Administrator (Under user Management > User (Code for the role UMX|OTA_LRNG_ADMIN)) to allow them to manage classes and enrolment's on OLM, Some people have had the responsibility end dated but not the roles and we want to review all access and clean these up.

Running oracle 12.1.3

Any Assistance would be appreciated

(I hope this was logged under the correct category, as nothing quiet match’s

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center