ERROR: permission denied for database control

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: 'pgsql-general General' <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: permission denied for database control
Date: 2014-05-07 06:14:40
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD0148C0F9@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've encountered a weird problem in PostgreSQL :

postgres=> create user test password 'test';

postgres=> grant select on pg_catalog.pg_database_size to test;

postgres=> grant execute on function pg_catalog.pg_database_size(name) to test;

--login as user test
postgres=> select current_user;
current_user
--------------
test
(1 row)

--query individual database size is fine
postgres=> select pg_database_size('postgres');
pg_database_size
------------------
25611884
(1 row)

--fails if try to get all db size in one sql
postgres=> SELECT current_date,pg_database_size(pg_database.datname) from pg_database;
ERROR: permission denied for database control

Thanks,
Suya

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif Jensen 2014-05-07 06:37:52 Re: Server process crash - Segmentation fault
Previous Message Sameer Kumar 2014-05-07 04:31:55 Oracle to PostgreSQL replication