From: | Eugene Karpachov <jk(at)steel(dot)orel(dot)ru> |
---|---|
To: | Stephan Szabo <sszabo(at)kick(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: grant select,update - bug or feature? |
Date: | 2000-05-30 12:40:23 |
Message-ID: | 20000530164023.A13129@steel.orel.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Mon, May 29, 2000 at 08:51:10PM -0700, Stephan Szabo write:
> This is a known issue in the 7.0 foreign key implementation. The short
Thank you, now it's clear for me.
> It's something that will get fixed, it's just a question of how and when.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
It's just what I want to know :)
> > create table master ( i integer primary key, a text);
> > -- I want to protect this table from updating by 'dbuser'
By the way, how can I make such a protection? Are triggers the only way?
> > create table slave ( j integer references master, b text);
> > -- I want to enable updating this table by 'dbuser'
> >
> > grant select on master to dbuser;
> > grant select,update on slave to dbuser;
--
jk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-05-30 16:09:45 | Re: few securiry questions |
Previous Message | Norbert Meissner | 2000-05-30 09:43:53 | Re: Bug or Feature ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Peterson | 2000-05-30 14:10:54 | Re: Postgresql usage clip. |
Previous Message | Ned Lilly | 2000-05-30 12:10:13 | Re: Postgresql usage clip. |