Grant access inside view

Database

Grant access inside view

Hi,

I  have created a view in dbadmin and that granted one user to access that view.... 

But its not fetching the data from that view.

I have granted the permission to the user also.....

grant select on dbadmin.topfive to canary1 with grant option;

1 REPLY
Enthusiast

Re: Grant access inside view

It might be that the view does not have permissions to select from another database.  Is it throwing a permissions error is just not pulling back any rows?

Joe