Received: from gandalf.it-austria.net (gandalf.it-austria.net [213.150.1.65])
	by hub.org (8.9.3/8.9.3) with ESMTP id EAA96658
	for <pgsql-hackers@postgresql.org>;
	Sun, 28 May 2000 04:36:03 -0400 (EDT)
	(envelope-from andreas.zeugswetter@telecom.at)
Received: from zeus (totalctlh1-port009.f000.d0188.sd.spardat.at
 [10.8.35.246])
	by gandalf.it-austria.net (xxx/xxx) with SMTP id KAA23590;
	Sun, 28 May 2000 10:35:47 +0200
From: Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
To: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>,
	Peter Eisentraut <peter_e@gmx.net>
Subject: Re: Proposal for enhancements of privilege system
Date: Sun, 28 May 2000 10:12:23 +0200
X-Mailer: KMail [version 1.0.29.1]
Content-Type: text/plain
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
References: <Pine.LNX.4.21.0005221915300.392-100000@localhost.localdomain>
	<3929D582.9372C87D@nimrod.itg.telecom.com.au>
In-Reply-To: <3929D582.9372C87D@nimrod.itg.telecom.com.au>
MIME-Version: 1.0
Message-Id: <00052810335406.00145@zeus>
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200005/746

On Tue, 23 May 2000, Chris Bitmead wrote:
> Peter Eisentraut wrote:
> 
> > pg_privilege (
> >     priobj oid,
> >     prigrantor oid,
> >     prigrantee oid,
> >     priaction char,
> >     priisgrantable boolean,
> > 
> >     primary key (priobj, prigrantee, priaction)
> > )
> > 
> 
> I like it.

Imho this is an area where it does make sense to look at what other db's do,
because it makes the toolwriters life so much easier if pg behaves like some other
common db. Thus I do not really like a standalone design.

Other db's usually use a char array for priaction and don't have priisgrantable, 
but code it into priaction. Or they use a bitfield. This has the advantage of only 
producing one row per table.

Andreas