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" ?


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.




Thank you Jose. This is a nice explanation :)

Hello there,

Where do I find these two entities? I need to get all the users which are assigned a specific role, but can't find the right way to do it.

Hi Ozan,

These are System Entities, and as such you can reference them from System.

OK, I found it. By default it was not referenced in my project, I opened the Manage Dependencies window and added the Entity. Thanks a lot.

Glad I could be of help :).