Forum Discussion
How to set permissions on sheets based on the scenario?
Hello,
I have scenario, where I made multiple lists in SPO. In AAD, I created three groups of users to whom I need to assign permissions to use sheets.
The first group of users (Employees) should have permissions:
He only sees his list items. He can only edit his items.
The second group of users (Managers) should have the following permissions:
They should see all the items in the list. But they can only edit their own.
The third user group (Admin) should have permissions:
They should see everything (all items) and can edit all items.
Ideally, Admins could not modify the list structure. Thus, they are not 1 to 1 with a predefined group (Site Owners).
Can anyone advise me how to set permissions based on how I wrote the script above?
Thank you very much for any advice that would move me to the goal.