Re: pgsql: More cleanup on roles patch.

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: More cleanup on roles patch.
Date: 2005-06-30 06:09:14
Message-ID: Pine.GSO.4.63.0506301003560.19218@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Wed, 29 Jun 2005, Stephen Frost wrote:

> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
>> Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
>>> Do we follow RBAC (http://csrc.nist.gov/rbac/) ?
>>
>> Personally, I'm reading SQL99 for this.
>
> I've been following an SQL2003 draft... That looks interesting but I
> think we probably want to stick to SQL..

we use RBAC for years as an external application and it's very nice to have it
built-in. I'm looking for possibility to check if given role have enough
privileges to perform some operation on some subset of data specified by
WHERE clause. For example, one role is granted full access the whole
catalog, while other could read all catalog and modify only part.

>
> Thanks,
>
> Stephen
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Neil Conway 2005-06-30 07:01:58 pgsql: Fix ecpg's test/ Makefile for out-of-tree (vpath) builds.
Previous Message James William Pye 2005-06-30 06:01:47 python - be: Add MANIFEST.in for sdist.