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
