You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Question on using PER_USER_ROLES table

Received Response
126
Views
3
Comments

Hi Friends

I'm quering the PER_USER_ROLES table to identify the list of users with their roles, and who/when it was updated.

Until now, only the security team has been assigning the roles manually or it gets auto provisioned based on the user position.

But, on the contrary, along with the security users name, I found many users name outside security (or business users) shows up on the last updated by field. They don't have any security access and wondering how it gets updated? Some shows it is manually assigned and some automatic.

The more frequent roles are Team Collaborator, Project Manager and Project Team member (manually assigned)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!