Where role are stored?

[ANAND KUMAR SHU]

Hi All,

Can any one confirm because I have some doubt on the below:

Role are stored in : sys_user_role (table)

User's role are stored in :  sys_user_has_role (table)

[Brad Bowman]

Yes, take a look at a list view of the sys_user_role table and you will see a record for each role name and other attributes.  The sys_user_has_role table is a link between the sys_user table and the sys_user_role table - with a reference column for user and a reference column for role, among other things

[Brad Bowman]

Did this answer your question?

[Rameshwar Khile]

Hi,

  All the roles mapped to user will be stored in sys_user_has_role table. Roles field is just to create a relationship with this table. So virtually no roles will be stored in sys_user (User) table.

Thanks

Rameshwar

If the reply was informational, please mark as helpful or mark as correct!