Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Roles and Privileges

Veeresh AttuluriFeb 27 2025

Example: User John Doe has 5 roles in production that each have several privileges:

  1. Role 1
    1. Privilege A
    2. Privilege B
    3. Privilege C
  2. Role 2
    1. Privilege D
    2. Privilege E
    3. Privilege F
    4. Privilege G
  3. Role 3
    1. Privilege H
    2. Privilege I
  4. Role 4
    1. Privilege J
    2. Privilege K
  5. Role 5
    1. Privilege L
    2. Privilege M
    3. Privilege N

What I’m looking for is a tool that can tell me that user John Doe hasn’t used Privileges A, D, H, I, K, or N over a given period of time. Based on that information I’d then be able to remove Role 3 since the user isn’t using either privilege, and I’d probably also evaluate if there’s a different role that the user could have instead of role 4 since the user only needs one of the privileges.

is this data stored in any of these tables

Comments
Post Details
Added on Feb 27 2025
0 comments
79 views