PUBLIC access to remote tables

[j2willi4]

if i have a view thats base table is local, but has columns from a remote table. PUBLIC has been granted VIEW to to all local and remote tables. Will the PUBLIC's permission to the remote table be represented if I check the permissions to the remote table?

try to read that 5 times fast.

Thanks!

 

[mberni]

if you do

grant all on mylocalview to PUBLIC;

and your view would look like this:

create view mylocalview (field1, field2) as
select a.f1, b.f2
  from localdatabase:localtable a,
       remotedatabase:remotetable b;

then some user would get results from that view, if he queries against localdatabase

select * from mylocalview;

Even if you would do

revoke all on remotetable for PUBLIC;

on the remotedatabase, he would still get results from that view.

if that user would try

select * from remotedatabase:remotetable;

instead, he would get error 272: no select permission