Grant Create Sequence in PostgreSQL

Question

Is it possible to grant a user/role only the permission to create/alter sequences in a PostgreSQL database/schema not allowing the user to create tables at the same time?

I currently use

GRANT CREATE ON SCHEMA myschema TO "MyRole";

which gives the user full create access to the schema, though he cannot delete or alter any tables that he does not own. My use case is that I use Liquibase to setup the database schema upfront and want to have the application only using a db user that can only read/write data. Unfortunately the application requires a dynamic number of sequences, i.e. it must be possible for the application to create new sequences in the database/schema.

score 1 · Accepted Answer · answered Feb 10 '22 at 12:09

1

The only possible way is to create an event trigger that throws an error if you create anything else than a sequence.

answered Feb 10 '22 at 12:09

Laurenz Albe

209,280
17
206
263

1

There is an [answer in db stack exchange](https://dba.stackexchange.com/questions/308616/create-sequence-permission-for-postgres/324872#324872) with an example – Daniel Mar 17 '23 at 16:04

score -2 · Answer 2 · answered Feb 10 '22 at 11:57

-2

You can do

grant select on sequence my_sequence in schema my_schema to my_role_user

https://www.postgresql.org/docs/14/sql-grant.html

answered Feb 10 '22 at 11:57

Philippe

1,714
4
17

Grant Create Sequence in PostgreSQL

2 Answers2