I run this command:
psql --username=openerp --dbname=sf_template_20150608111121 --no-password \ --command="update pg_database set datallowconn = false \ where datname = 'sf_template_20150608111121'"
I use the
openerp user to create all my databases. However, I get this error message:
ERROR: permission denied for relation pg_database
Why can't I access such table in my database? (again: the user is the actual creator of the database). My aim is to fully disable connections to this database.