RE: [ADMIN] User based access

Hi,

You need to look at the GRANT and REVOKE commands in the SQL documentation.

e.g. to allow harold read-only on table contacts command (run by table
owner) would be similar to:


REVOKE all ON contacts FROM harold;
GRANT select ON contacts TO harold;

and to deny a user access to a table just REVOKE all the privileges from
them.

Regards,

Neil


> -----Original Message-----
> From: owner-pgsql-admin@postgreSQL.org
> [mailto:owner-pgsql-admin@postgreSQL.org]On Behalf Of Gregg Berkholtz
> Sent: 08 January 1999 07:52
> To: Paul Dwerryhouse
> Cc: pgsql-admin@postgreSQL.org
> Subject: Re: [ADMIN] User based access
>
>
> On this same note, can you restrict a certain user to just
> read-only and allow
> others to have write access to certain tables. If so, how would I
> go about this?

> Paul Dwerryhouse wrote:
>
> > Hi all,
> >
> > Would I be correct in saying that there is no way to allow a
> few users to
> > have access to a database, but deny others, under Postgresql?
> >