From: | "Neil Burrows" <maillist(at)remo(dot)demon(dot)co(dot)uk> |
---|---|
To: | <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | RE: [ADMIN] User based access |
Date: | 1999-01-08 09:11:37 |
Message-ID: | 000001be3ae6$e53ef4b0$c6cb9284@towhee.gssec.bt.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgreSQL(dot)org
> [mailto:owner-pgsql-admin(at)postgreSQL(dot)org]On Behalf Of Gregg Berkholtz
> Sent: 08 January 1999 07:52
> To: Paul Dwerryhouse
> Cc: pgsql-admin(at)postgreSQL(dot)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?
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Taylor | 1999-01-08 09:53:08 | How to clear a lock? |
Previous Message | Gregg Berkholtz | 1999-01-08 07:52:28 | Re: [ADMIN] User based access |