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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
24 views