Want to give user account access to multiple tables simultaneously

[souravpoddar]

Hi,

I am trying to give a user account access to 17 tables. But currently giving both row level and field level access individually for each table is very tedious and time consuming. Is there a way I can do it simultaneously for all 17 tables - both row level and field level?

[Dr Atul G- LNG]

Hi @souravpoddar 

What do you mean by row-level and table-level? Are you referring to ACLs? Or, as you mentioned, table access—what role does the table require? Just make sure that role is added to the user account. If it's ACL-related, there's no workaround—you'll need to configure both row-level and table-level access.

[souravpoddar]

Yes I am referring to ACLs. I am not sure what roles map to the corresponding tables. The tables I need to grant access to are:

1. kb_knowledge

2. kb_uc_can_read_mtom

3. kb_uc_can_contribute_mtom

4. kb_uc_cannot_read_mtom

5. kb_uc_cannot_contribute_mtom

6. sys_user

7. sys_user_has_role

8. sys_user_grmember

9. user_criteria

10. kb_knowledge_base

11. sys_user_group

12. sys_user_role

13. cms_location

14. cmn_department

15. core_company

16. sys_db_object

17. sys_dictionary

[muhammadosama55]

You can write a Business Rule or a Script Include to programmatically create ACLs for each of the 17 tables. This way, you can automate both the field-level and row-level ACL creation for multiple tables simultaneously.

Steps:

1. Define Tables and User Permissions: Create a script that loops over all 17 tables and applies the ACLs for both field-level and row-level access.

[souravpoddar]

I am not very much familiar with script. Can you share a sample link or script/business rule that I can use?