Restrict access to certain records

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
eagle
Veteran Member
Posts: 39
Joined: 2013-01-09 15:38

Restrict access to certain records

Post by eagle » 2021-01-25 19:12

I have a setup like this

# Category table:

id
category_name
visible_to_executives (can be Yes or No)


# Transaction records table:

id
category (lookup field to categories.id )
more data fields

1) Only users that are "executives" should be able to select categories where category.visible_to_executives = 1

1b) Ideally they should not know that such categories exist at all in my application.

2) Only users that are "executives" should be able to see *transactions* that are linked to a category where category.visible_to_executives = 1

Is it possbible to set up this scenario?

Thanks a lot for all help.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Restrict access to certain records

Post by onoehring » 2021-01-26 08:23

Hi,

please check me footer for Column-Value-Based-Permissions. This might help you.

Olaf

eagle
Veteran Member
Posts: 39
Joined: 2013-01-09 15:38

Re: Restrict access to certain records

Post by eagle » 2021-01-26 13:05

Thanks a lot, Olaf. That seems like exactly what I was looking for :)

Post Reply