citusdata / citusdata/citus

Misleading error message when trying to CREATE DATABASE with insufficient permissions

Open
#2,439 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

When a user that does not have permission to create a database attempts to do so and fails, they get the following NOTICE message, which could lead to end user confusion:

```
citus=> create database foo;
NOTICE: Citus partially supports CREATE DATABASE for distributed databases
DETAIL: Citus does not propagate CREATE DATABASE command to workers
HINT: You can manually create a database and its extensions on workers.
ERROR: permission denied to create database
```

I'd suggest only adding the NOTICE message if the user has permissions to create the database.

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.