Answer the question
In order to leave comments, you need to log in
How to give all rights to the database?
Hello everyone
, I did grant all privleges on database to user, postgres said it was ok, but when I try to write, permission denied still occurs and I have to manually write grants for tables, schema, sequences, functions.
Please tell me why it does not issue all permissions to the user on grant all privleges on database and how to register all restrictions?
Answer the question
In order to leave comments, you need to log in
Here , in fact, the answer to the question why grant all privleges does not do what you expect from it.
In general, if you create the first user for a new database, you should make that user the owner of that database. Executed as superuser:
alter database DB_NAME owner to USER_NAME;
If you want to add a second user with full rights, you will have to iterate over all types of allowed operations for all types of database objects.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question