Skip site navigation (1) Skip section navigation (2)

Re: grant select,update - bug or feature?

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

In response to

pgsql-admin by date

Next:From: Peter EisentrautDate: 2000-05-30 16:09:45
Subject: Re: few securiry questions
Previous:From: Norbert MeissnerDate: 2000-05-30 09:43:53
Subject: Re: Bug or Feature ?

pgsql-general by date

Next:From: Ron PetersonDate: 2000-05-30 14:10:54
Subject: Re: Postgresql usage clip.
Previous:From: Ned LillyDate: 2000-05-30 12:10:13
Subject: Re: Postgresql usage clip.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group