Contents
How to allow user to access view but not tables behind the view?
If so, then you would have to create the user in the other database and give them access in that other database also. Problems are opportunities brilliantly disguised as insurmountable obstacles. Just grant SELECT permissions on the view and don’t grant SELECT permissions on the underlying tables.
Can you give select access to a table?
I cannot give them select access to the tables because then the user could see all of the data in the table and I don’t want that. When the user tries to query the view they get the message “The SELECT permission was denied on the object ‘table_name’, database ‘database_name’, schema ‘db_owner'”.
Can You grant select to the view but not the base table?
I’d like to grant select access to the view, but not direct access to the base table. The view has a where clause restricting the number of rows. Can I grant select to the view and not the base table, or do I need to switch to a stored procedure? I would rather not do it the latter way.
How to grant access to a view in SQL Server?
A supplement. You should know that there’re 5 kinds of permissions that you can grant for user on a view in SQL Server. DELETE, INSERT, REFERENCES, SELECT, UPDATE. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?view=sql-server-2017
When do you not have permission to access a web part?
You do not have permission to perform this action or access this resource. Correlation ID: 24f0409d-8095-2000-2272-c31dae19c33e. I have the same page on SharePoint 2010 foundation and there if this user logs in, it would simply not display the web part that the user does not have access to.
Can you deny a user access to a view?
If you want the user to be able to query the view and only certain columns in the underlying tables you can explicitly deny SELECT permissions on the columns in the table you don’t want them to see. I specifically didn’t give them db_datareader because I don’t want to have to maintain the user/table when tables are added to the database.
Can a user select out of a view?
I’ve given the user the ability to select out of the views but not the tables. I cannot give them select access to the tables because then the user could see all of the data in the table and I don’t want that.