How to create read only ACL for custom table?

evogel
Tera Contributor

Hello!

How to create read only ACL for custom table? This worked in the dev, but not the test instance.

To be specific:

  • A catalog request uses a variable that references this table.
  • The catalog request is open to any SN user that can log in.
  • All values in the table should be accessible with ready-only permission to any user. Just a long list of available systems.
  • Only admins should create or modify.
  • Catalog item variable works in the dev instance, but not our test instance?

Steps taken:

  • Using elevated role security_admin.
  • Recreated the ACL on test.
  • Checked "Create access controls" and used 'user.'
  • Removed "user" role from the ACL with read operation.
  • Added an ACL record to read all table contents, and removed user role requirement from below.

This thread is closely related, but no resolution there either.

Same setup for Dev and Test

8-18-2017 3-44-53 PM.jpg

ACL execution in Dev:

8-18-2017 3-49-56 PM.jpg

ACL execution in Test:

8-18-2017 4-11-51 PM.jpg

The additional ACL record created to just read, without role required.

8-18-2017 4-18-28 PM.jpg

End result in Test. Dev shows all the choices while impersonating the same user (who has no roles assigned).

8-18-2017 4-14-20 PM.jpg

What am I missing here?

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron

Hi Edward,



Try changing it to None.


find_real_file.png


View solution in original post

9 REPLIES 9

krr
Mega Guru

In case it's the same issue, this week I promoted an application from dev to prod and none of the ACLs restricted access in prod where they did in dev. Even ESS users with no role could read and edit.



I was testing via impersonation.



After an hour of pulling my hair out, I opened a Chrome Incognito window to test as a new session and logged in as my admin account. Impersonating another user then did properly restrict their access.



It appeared to mix my admin access in with the user I was impersonating in the non-incognito window.



Not sure if is the same thing I ran in to, but sounds similar.


evogel
Tera Contributor

No fix. Tried logging in with dedicated Test User that has no roles assigned, on a different browser. Same effect.


kartik8
Kilo Contributor

Hi Edward,



For The additional ACL record created to just read, without role required part can you create table.none acl instead of table.*?


evogel
Tera Contributor

No fix. Tried this and the list collector still shows no matches for results.