How to allow 4 users to see all records?
EDIT: As discussed in comments below, you will also need to grant your 4 users “Cancel Checkout” permissions for them to be able to see all records/entries. you can get this with little effort. unchecking View Items checkbox under List settings. Checking Add Items checkbox under List Settings.
What happens if I give a view permission?
However, if I give them the CREATE VIEW permission, they are still getting a permission error when creating the view. I want them to create all the views in a given schema, which matches that of the tables they are building views on. How do I solve this issue?
Can a user see all entries in a list?
Any help would be much appreciated. This allows users to only view and only edit their own records/entries in the list. EDIT: As discussed in comments below, you will also need to grant your 4 users “Cancel Checkout” permissions for them to be able to see all records/entries.
Are there any issues with the create table permissions?
There is one issue with this set of permissions, however. Because the user has ALTER permissions on the dbo schema, the user can alter and even drop objects within that schema. This includes tables, which isn’t obvious at first because usually you would think that without CREATE TABLE permissions, the user couldn’t do anything with the tables.
How to get permission to add items to list?
you can get this with little effort. unchecking View Items checkbox under List settings. Checking Add Items checkbox under List Settings. on list permission settings, apply the new permission level to user or Group. Now add the 4 super user with required level of permission.
How to deny user from seeing / selecting from tables?
If I grant select on MyView but DENY Select on Table1, where Table1 is the source for MyView, it appears as if the DENY select prevents the View from selecting from the table. My ultimate goal is to prevent users from seeing tables/view via ODBC that they should not be able to see, the should only see the views where I control what the can select.