Re: users rights per table

Lists: pgsql-general
From: victor <victor(at)ambra(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: users rights per table
Date: 2004-05-01 18:05:53
Message-ID: 4093E701.4000404@ambra.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

I have to implement a structure of rights.
I'm intrested if postgresql can restrict these operations(insert,
update, select, delete) for a specified postgresql user.
If this is possible, please tell me were could I find some
documentation about this subject.

Thank you.

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: victor(at)ambra(dot)ro (victor)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: users rights per table
Date: 2004-05-01 19:00:34
Message-ID: 200405011900.i41J0Z1I030915@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

> I have to implement a structure of rights.
> I'm intrested if postgresql can restrict these operations(insert,
> update, select, delete) for a specified postgresql user.
> If this is possible, please tell me were could I find some
> documentation about this subject.

Can we assume that you have not yet read the section on 'GRANT'
in the online documentation on the postgreSQL website?
--
Mike Nolan

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: victor <victor(at)ambra(dot)ro>, pgsql-general(at)postgresql(dot)org
Subject: Re: users rights per table
Date: 2004-05-01 21:01:39
Message-ID: 200405012301.39147.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

victor wrote:
> I have to implement a structure of rights.
> I'm intrested if postgresql can restrict these
> operations(insert, update, select, delete) for a specified postgresql
> user.
> If this is possible, please tell me were could I find some
> documentation about this subject.

Read the reference page of GRANT.