Unable to update users table when using normal account / admin account will work

[Jeck Manalo]

Hi Everyone,

I have a question, when I process the request using my admin account this below script is able to work.

But when I am using my normal account this is not working.

Is there something that I need to do to make it work using my normal account when processing the request ?

viewing of user table in admin account = editable

viewing of user table normal account = not editable

[AnubhavRitolia]

Hi Jeckson,

ACL must be present for the particular field to restrict non admin to edit it. Verify ACL once related to User table and this field.

Please mark this solution as correct answer and helpful if this help you reach towards solution.

[Mahendra RC]

Hello Jeckson,

I believe this is because of write ACL on sys_user.active field as shown below. As per the ACL only users with admin or user_admin role should be able to update the active field on sys_user table. Try to run this script with user having user_admin role and if the active field is updated then you have to make change in this ACL.

Please mark my respsone as helpful/correct, if it answer your question.

Thanks

[Jeck Manalo]

Hi Mahendra,

Thanks I know that solution will work but role will not be possible to provide to normal account.

I have another option to make it on flow designer.

I use look up record but how can i get all the record using look up is there something that can we do ?

[Mahendra RC · Accepted solution]

Hello Jeckson,

There will be an action Look up Records and using that you can get all the records matching your condition. Also you have to make flow to run as System user otherwise I think the ACL will not allow to update the active field on sys_user table.

Please mark my respsone as helpful/correct, if it answer your question.

Thanks