Re: Oracle and Postgresql - Mailing list pgsql-general

From Casey Allen Shobe
Subject Re: Oracle and Postgresql
Date
Msg-id 6E1D73AB-E5BF-4D4B-B9F4-DADF3A65F5C1@bepress.com
Whole thread Raw
In response to Re: Oracle and Postgresql  (David Fetter <david@fetter.org>)
List pgsql-general
On Sep 15, 2008, at 6:58 AM, David Fetter wrote:
>> Roles,
>
> We have 'em.

We do NOT have secure application roles or anywhere near the level of
configurability in security aspects as Oracle.  We've got a great
foundation, but we lack a lot of fine-grained granularity (e.g. an
Oracle SAR can allow a role to execute a particular function based on
the result of another function call or query, which has rather a lot
of possibilities - consider grant connect on database to staff when
hour_of_day () between 9 and 6; also consider row-level and column-
level and even field-level access controls).

It's complicated in Oracle, but there's a lot of possibilities there
that we simply cannot reproduce.  But this could be extended one day. :)

Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to select rows that are the max for each subcategory?
Next
From: Casey Allen Shobe
Date:
Subject: Re: Oracle and Postgresql