How to: Select a ’sys_user’ Table in a Reference Type Item

Mi1 · ‎04-25-2022

Hi,

I keep the 'delegated developer' role and the 'user admin' role.

I want to prepare a reference type item in the table, but I can't select a 'sys_user' or 'cmn_department' table.

How can I make a choice?

Best Regards,

Musab Rasheed · ‎04-26-2022

Hi,

Yes , ask those who have admin + security admin roles to edit record read ACLs of user and department table and include 'delegated_developer' role to read them. Don't forgot to mark my answer as correct if that helps.

Please hit like and mark my response as correct if that helps
Regards,
Musab

View solution in original post

Musab Rasheed · ‎04-26-2022

Hi Mi,

Do you have access to user or department table.? also is this happening here or elsewhere too.? lastly try first giving label name and column.

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab

Mi1 · ‎04-26-2022

Hi,

Thanks for the comment.

I can view 'sys_user' tables and details records from a menu called 'User Administration'.

This is the only option that cannot be selected.

Best Regards,

Musab Rasheed · ‎04-26-2022

I see security constraint message that means you don't have access to all tables starting with 'sys_user', do you have 'admin' access..??

Please hit like and mark my response as correct if that helps
Regards,
Musab

Mi1 · ‎04-26-2022

Thank you.

I'm a delegated developer, so I don't have 'admin' access.

I had a 'user admin' access , so I thought it was accessible.

Do I need to set up ACL to access only 'User' , 'Department', tables?

Best Regards,