Question on using PER_USER_ROLES table
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)
Tagged:
0