Difference between user_role and User_Effective_Role

Difference between user_role and User_Effective_Role

  

Hi all,

can anyone tell me the basic difference between system entities  "user_role" and "User_Effective_Role" ?

Solution

Hi Debasis,

User_Role will have the roles attributed directly to the User.

User_Effective_Role will have all the Roles for the User. The ones attributed directly and the ones attributed through the Groups.

Cheers,

José

Solution

Thank you Jose. This is a nice explanation :)