How to limit user access to table ?

Irek1
Giga Contributor

I can't limit user to create or delete records in my custom table. In the table Controls tab , I created access controls with user role u_table-name_user . I don't have any users with this role in the system, thou users can create or delete records in that table?

When I enable debug security rules, and I impersonate user which shouldn't have been able to delete records I can see this below after impersonated user deleted record A..3011:find_real_file.png

8 REPLIES 8

Irek1
Giga Contributor

I have this pretty standard acl  for user role _robo_user role which I've not assigned anywhere yet...find_real_file.png

can you provide screenshot of your delete ACL?

There may be issue in conditions, script of your delete ACL.

Is your table extended from any base tables? if yes, you may have to check delete acl on your base table.

 

Regards,

Sachin

Irek1
Giga Contributor

My table doesn't extend any table. Conditions shows all records which can be deleted correctly

find_real_file.png

That looks fine then.  You might try clearing the instance cache by navigating to '/cache.do' to see if that helps.