Permissions on new field in Sys_user table

riaz_mansuri · ‎05-18-2017

Hi,

Currently the sys_user table is read only for users with an ITIL licence.

I want to create a new field and give write permissions to users with an ITIL licence or better yet only to a specific group.

Does anyone know how I can achieve this?

Thanks,

Riaz

SanjivMeher · ‎05-18-2017

To create an ACL, you need security_admin role.

Open System Security-> Access control and create an ACL with table as sys_user and field name as your new field name.

On the bottom, add the new role you created.

Then grant that role to the group.

Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

SanjivMeher · ‎05-18-2017

Create an acl on that field and give access to a new role. Add that role to the group who will have access to write.

Access control rules

Please mark this response as correct or helpful if it assisted you with your question.

Niklas Peterson · ‎05-18-2017

Add an ACL for the new field.

Access control rules

Regards,

Niklas

riaz_mansuri · ‎05-18-2017

Not to sound rude but I was hoping for a little more help.

Some details would be great, maybe a few steps

Niklas Peterson · ‎05-18-2017

Sorry, you won't get more from me. You shouldn't touch the ACL's unless you really know what you are doing. Can make a mess otherwise. But please go ahead and follow the link. It's not that hard to learn what to do.

No hard feelings I hope!

Regards,

Niklas