Grant all privileges to user on a database

From: Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Grant all privileges to user on a database
Date: 2023-07-24 13:15:42
Message-ID: CAD7Ssm9fFBRN0+YssRgXmx7yECsunDg7kL_r2Yowh-3iD9tFTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am running postgresql15-server 15.3 on Red Hat Enterprise Linux
release 8.7 (Ootpa)

# rpm -qa | grep -i post
postgresql15-server-15.3-2PGDG.rhel8.x86_64
postgresql15-libs-15.3-2PGDG.rhel8.x86_64
postgresql15-15.3-2PGDG.rhel8.x86_64
#

$psql
psql (15.3)
Type "help" for help.

postgres=# GRANT ALL PRIVILEGES ON DATABASE cbdevdb TO cbdevdbadmin;
postgres=# \du
List of roles
Role name | Attributes
| Member of
--------------+------------------------------------------------------------+-----------
cbdevdbadmin | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=#

Am I missing something? Please suggest. Thanks in advance.

Best Regards,

Kaushal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-07-24 13:17:45 Re: \d don't print all the tables
Previous Message Sabri Taner Burak ALTINDAL 2023-07-24 13:01:34 Error 503 Backend fetch failed