How to set read permissions from a view without read permissions from a table?

V

Vitaly Chura2014-12-15 16:18:20

SQL Server

Vitaly Chura, 2014-12-15 16:18:20

Good afternoon!
Please tell me, is it possible to give the user the rights to read from the view without issuing him the rights to read from the tables that this view consists of?
Thank you in advance!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vitaliy Chura, 2014-12-19
@Fitter1990

Can you please tell me how to check permissions?
execute as user=TestUser
select * from View1
revert
Or you need to ask the user