Query to a view doesn't work if you grant permission to it without granting permission to underlying table
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Steps to reproduce:
```
create table test_table (col1 int);
select create_distributed_table('test_table','col1');
create view test_view AS (select * from test_table);
grant select on test_view to test_role;
```
As test_role
```
select count(*) From test_view;
WARNING: permission denied for relation test_table_104453
WARNING: permission denied for relation test_table_104454
WARNING: permission denied for relation test_table_104455
WARNING: permission denied for relation test_table_104456
WARNING: permission denied for relation test_table_104457
.........
```
The same thing works on Postgres (i.e. non-distributed) tables.
Contributor guide
Assessment
This issue has not been assessed yet.