psql

psql

January 27, 2025 | permanent

tags :

SQL language for PostgreSQL #

OCI and clix e-invoicing project ATTACH #

# connect the adminUser (superuser) in CLI mode
psql "sslmode=require host=localhost port=5434 user=adminUser dbname=postgres"

# then for user clix_production
postgres=> GRANT CONNECT ON DATABASE clix_production TO clix_production;

# for production user
GRANT CONNECT ON DATABASE clix_production TO "adminUser";

This results in the following privileges


No notes link to this note

Go to random page

Previous Next