1

Topic: Help with grants

Good afternoon, there is a type label
[ProdDB]. [sch]. [some_table]
Is  type
create view [RepDb]. [rep]. [some_table_view] as
select * from [ProdDB]. [sch]. [some_table]
There is server user RepUser for which is grant select on [RepDb]. [rep]. [some_table_view]
PROBLEM:
At attempt of a choice from [RepDb]. [rep]. [some_table_view]
The message 229, level 14, state 5, line 1
Resolution "SELECT" on object [some_table databases "ProdDb", circuits "sch" is forbidden.

2

Re: Help with grants

MeGusta;
https://docs.microsoft.com/en-us/dotnet … sql-server

3

Re: Help with grants

Thanks