Change the owner to xxx too. Rodrigo Dev Visite: https://rodrigoluna.net.br YouTube: GamesBR
> Em 1 de fev. de 2023, à(s) 17:15, Rodrigo Luna <rodrigomrlun...@gmail.com> > escreveu: > > 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?
