Grant all privileges to user on a database - Mailing list pgsql-general

From Kaushal Shriyan
Subject Grant all privileges to user on a database
Date
Msg-id CAD7Ssm9fFBRN0+YssRgXmx7yECsunDg7kL_r2Yowh-3iD9tFTw@mail.gmail.com
Whole thread Raw
Responses Re: Grant all privileges to user on a database
List 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



pgsql-general by date:

Previous
From: Sabri Taner Burak ALTINDAL
Date:
Subject: Error 503 Backend fetch failed
Next
From: Ron
Date:
Subject: Re: \d don't print all the tables