Jeff wrote:
On Thu, 06 Nov 2003 23:59:29 +0100
Gaetano Mendola <[EMAIL PROTECTED]> wrote:
Already asked, I try again:
7.4 give the feature to have transaction in
read only mode, is it possible give permission
to an user to perform db connection in read only
mode ?
create user readonlyuser;
revoke insert on [table] from readonlyuser
revoke update on [table] from readonlyuser
revoke delete on [table] from readonlyuser
I know but is not system/tables wide.
Each time that a table is created I shall remember
to revoke the permission, what I was looking for
was an option to insert into pg_hba.conf
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
