Hey gvim,
2010/12/30 gvim
> Is it possible, with PostgreSQL 9.0, to restrict access to specific table
> rows by `id`? I want a user to be able to INSERT new rows but not UPDATE or
> DELETE rows with `id` < 1616.
>
I believe that first you need to restrict SELECT. You can do it by creating
view:
On Thu, Dec 30, 2010 at 7:30 AM, gvim wrote:
> I want a user to be able to INSERT new rows but not UPDATE or
> DELETE rows ...
This part is easily done:
http://www.postgresql.org/docs/9.0/interactive/sql-grant.html
http://www.postgresql.org/docs/9.0/interactive/sql-revoke.html
http://www.postgres
On 30 December 2010 16:30, gvim wrote:
> Is it possible, with PostgreSQL 9.0, to restrict access to specific table
> rows by `id`? I want a user to be able to INSERT new rows but not UPDATE or
> DELETE rows with `id` < 1616.
>
> gvim
>
>
I think the simplest way would be creating a trigger in whi
Is it possible, with PostgreSQL 9.0, to restrict access to specific table rows by
`id`? I want a user to be able to INSERT new rows but not UPDATE or DELETE rows
with `id` < 1616.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h