citusdata / citusdata/citus

Support GRANT ... ON DATABASE TO ...

Open
#7,096 1 comment 0 reactions 1 assignee Claimed by @gurkanindibay View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

We don't propagate `GRANT ... ON DATABASE ...` currently

1. log in as superuser
2. CREATE USER myuser
3. GRANT CREATE ON DATABASE postgres TO myuser;
4. connect as myuser
5. CREATE SCHEMA myschema;
6. Now you get an error:
```
ERROR: 42501: permission denied for database postgres
CONTEXT: while executing command on localhost:9701
```

Note: `GRANT CREATE | CONNECT | TEMPORARY | TEMP ...` should all be supported.

Subtask of #4812

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.