Even on the create role you set login? Rodrigo Dev Visite: https://rodrigoluna.net.br YouTube: GamesBR
> Em 1 de fev. de 2023, à(s) 17:13, Siddharth Jain <siddh...@gmail.com> > escreveu: > > >> >> >>> using Postgres 14.4, I created a database as the postgres user: >>> >>> create database xxx; >>> >>> postgres=> \c xxx >>> psql (13.9 (Debian 13.9-0+deb11u1), server 14.4) >>> WARNING: psql major version 13, server major version 14. >>> Some psql features might not work. >>> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: >>> 256, compression: off) >>> You are now connected to database "xxx" as user "postgres". >>> >>> i gave all privileges on xxx to user sysbench: >>> >>> postgres=> GRANT ALL PRIVILEGES ON DATABASE xxx TO sysbench; >>> >>> i can see: >>> >>> Name | Owner | Encoding | Collate | Ctype | >>> Access privileges >>> --------------+------------------+----------+---------+---------+--------------------------------------- >>> xxx | postgres | UTF8 | C.UTF-8 | C.UTF-8 | >>> =Tc/postgres + >>> | | | | | >>> postgres=CTc/postgres + >>> | | | | | >>> sysbench=CTc/postgres >>> >>> but user sysbench is not able to connect to this database: >>> >>> sysbench=> \c xxx >>> FATAL: database "xxx" does not exist >>> Previous connection kept >>> >>> how can i fix this?
