dbt-labs / dbt-labs/redshift

This package should document what permission are needed to use these views

Open
#13 4 comments 1 reaction 0 assignees View on GitHub
Dominant language
PLpgSQL
Stars
105
Forks
39
PR merge metrics
No merged PRs in 30d

Description

My default analyst role doesn't have the ability to view this relation:

```
dwh=> select * from redshift_admin.table_stats limit 5;
ERROR: permission denied for relation stv_tbl_perm
```

Nor this one:
```
dwh=> select * from redshift_admin.users_table_view_privileges limit 5;
ERROR: permission denied for schema
dev
```
Important to note, the `dev` schema doesn't even _exist_ at this point (I dropped it earlier today).

It seems like these views are only queryable by admins :/

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.