Re: (unknown) - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: (unknown)
Date
Msg-id iq38ob$2vh$1@dough.gmane.org
Whole thread Raw
In response to ...  (Didik Prasetyo <prasetyodidik62@yahoo.com>)
List pgsql-admin
Didik Prasetyo wrote on 07.05.2011 09:28:
> I want to ask how to make GRANT, where users can only perform SELECT
> on all the TABLE, in the database, which I have done the following

You might consider upgrading, because since 9.x you can do:

GRANT SELECT ON ALL TABLES IN SCHEMA public;

Thomas

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Re:
Next
From: Tomasz Chmielewski
Date:
Subject: Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?