On 7/24/23 08:15, Kaushal Shriyan wrote:
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.
No, you aren't. Role attributes are not the same as table privileges. -- Born in Arizona, moved to Babylonia.
