Support GRANT ... ON DATABASE TO ...
Open
- 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
Assessment
This issue has not been assessed yet.