citusdata / citusdata/citus

Query to a view doesn't work if you grant permission to it without granting permission to underlying table

Open
#1,683 3 comments 3 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.