neral'
Subject: Re: [GENERAL] ERROR: permission denied for database control
Albe Laurenz writes:
> Suya Huang wrote:
>> --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
Albe Laurenz writes:
> Suya Huang wrote:
>> --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
> It seems like you have a database called "control" for which u
Suya Huang wrote:
> 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;
This statement produces an error:
ERROR: relation "pg_catalog.pg_database_size" does not exist
> postgres=> g
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;
