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 по дате отправления: