Query to review access to roles allocated under User Manager
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