What is the significance of 'ACTIVE' field on User role table?

[Suggy]

What is the significance of 'ACTIVE' field on User role table <sys_user_has_role>?

Even if the user on user table is active/locked out/inactive, the STATE field on sys_user_has_role is always showing TRUE

[Pavankumar_1]

Hi,

That State field is set when you add a specific role to user.

if you remove the role of user record will be deleted under( sys_user_has_role)

If you add role to user it will create a record on this table sys_user_has_role

State is active default.

If it is active user has role and for other states user requested but not provided the role.

Hope it helps!!

Please Mark ✅ Correct, Thanks!! 

Regards

Pavankumar

[Suggy]

Hi Pavan,

I did not understand your statement "If it is active user has role and for other states user requested but not provided the role."

[Pavankumar_1]

Hi,

for example when you add any role to the existing users then record is created on this table(sys_user_has_role) and State is Active.

But if a user requested for a role from catalog item then we use as Pending Approval and once

approved then only State is Active 

Thanks,

Pavankumar