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,

Out Of  Box we have state field but it is related to address.

if Active is true field represents the users which are presents on the ServiceNow and will do tasks or based on the role other criteria they will perform.

If Active is false they will not able log into the ServiceNow.

Hope it helps!!

Please Mark ✅ Correct, Thanks!! 

Regards

Pavankumar

[Harneet Sital]

Hi Suggy, 

This is on the user role relationship table, this signifies whether the current state of the relationship of the role against the user is active or still under approval for processing. Below community answer would help you further understand this better - 

https://community.servicenow.com/community?id=community_question&sys_id=590f0a96dbb0451007ab82630596...

Thanks
-Harneet Sital (ServiceNow Certified Technical Architect)
Find all my ServiceNow articles here

[Suggy]

Hi @Harneet Sital Under which scenario it will be marked as "Pending Approval"?

I still did not understand the significance of 'STATE' field in sys_user_has_role table.

[Harneet Sital]

Hi @Suggy 

Pretty sure below community post will help you further with your queries -

https://community.servicenow.com/community?id=community_question&sys_id=590f0a96dbb0451007ab82630596...

If still not, I will try and summarize it further for you from all sources where I can find more information. 

Thanks
-Harneet Sital (ServiceNow Certified Technical Architect)
Request you to please mark my answer as helpful or correct based on the impact
Find all my ServiceNow articles here