Give read access to itil role to the customer_account table.

Samiksha2
Mega Sage

Hi All,

I am stuck in the read access to itil role to the customer_account table.

I created read ACL on customer_account table and added ITIL role.

Samiksha2_0-1717161210775.png

But it is not working.

Please let me know what I am doing wrong.

 

Thanks,
Sam

 

1 ACCEPTED SOLUTION

What's the reason the OOB 'company' field is not being used on the sc_req_item table?

View solution in original post

11 REPLIES 11

Hi @Kieran Anson and @Shashwat Rao ,
As you both recommended not to create ACL for account. I created a single text line and copied the value of account in that. I hope it works for them.
Thanks,
Sam

The recommendation wasn't to completely avoid creating ACLs. It was to not create ACLs with roles crossing multiple products.

By introducing a string field to which you copy a value, you've implemented technical debt. What happens if the account name changes? The new name won't be copied over

Hi @Kieran Anson ,
I didnt think about this. But the issue is ACL is not working. How to achieve this?

Thanks,
Sam

On what basis do you want these users to see account records. Should they just have visibility of the account name? The entire record?

Hi @Kieran Anson ,
Name will be fine. 

So basically, in all catalog items there is a field called Account(reference to customer_account table) . 

Now the requirement is user can search the account in the RITM List view.(Not based on catalog item variable). 

To achieve that I created a reference field in the RITM table and copying the value of account variable so that user can filter account in the RITM list view.
Thanks,
Sam