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

Re: refint/acl problem

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Stephan Szabo <sszabo(at)kick(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: refint/acl problem
Date: 2000-06-24 11:48:22
Message-ID: Pine.LNX.4.05.10006241336160.5015-100000@pc10.radnoti-szeged.sulinet.hu (view raw or flat)
Thread:
Lists: pgsql-hackers
> Probably the correct way to handle this is to run the foreign key
> constraint trigger as the user who created the constraint (or
> something like that) rather than the user making the insert.  I'm not
> sure how hard that would be.
The problem is that now using both refint and GRANT/REVOKE will not work
together. Only if I have separate areas of tables, I can assure that each
user may work on his own area. But most databases have referencing tables
which parent table is read-only for the simple users and child tables are
read-write for them. My opinion is that it is neccessary to allow such
referencing. If Postgres doesn't support this, almost nobody can use
refint and ACLs together. Performance is also important, I do know...

Regards,
Zoltan


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2000-06-24 11:58:03
Subject: Re: Makefile.global is kind of a pain
Previous:From: Kovacs Zoltan SandorDate: 2000-06-24 10:25:01
Subject: Re: problem with ALTER GROUP

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