Grant all privileges to user on a database

Поиск
Список
Период
Сортировка
От Kaushal Shriyan
Тема Grant all privileges to user on a database
Дата
Msg-id CAD7Ssm9fFBRN0+YssRgXmx7yECsunDg7kL_r2Yowh-3iD9tFTw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Grant all privileges to user on a database
Список 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 по дате отправления: