How to give read only access to hardward model to certain users?

[Gudu]

Hi Team,

I have a requirement to give read and write access to 3 users on hardward model table ([cmdb_hardware_product_model]) . I opened this menu and can see that model_manager has the right to see this model. 

so now my question is if i want to give access the users who need write acess then i can give model_manager role so that he can read/write the hardware model. 

but how can i give read access to users who has itil role only , please suggest?

[Bert_c1]

Login as admin, then use the Elevate Role and select security admin. Next go to the table record in 'sys_db_object' for the 'cmdb_hardware_product_model' table, in the related list of "Access Controls", either add 'itil' to one of the existing records for 'read' access, or create a new ACL for 'read' and add the 'itil' role.

[Gudu]

Hi Bert,

Thank you for your quick response. 

I tried creating a new acl on the table but this is showing this, could you please help me on this. 

[Bert_c1]

hi Gudu,

I was successful in adding an ACL for 'read' on the 'cmdb_hardware_product_model' table.

despite what you report on some table as "Masking". My guess is that the UI is letting you know the ACL won't apply to parent tables.

Create the ACL and test. See:

exploring-access-control-list

for more

[Voona Rohila]

Hi @Gudu 

Please check if there are any existing write ACL's on cmdb_hardware_product_model table, You can add based on role or you can create a new Write ACL with advanced script to provide access only for 3 users.