Re: execute permissions of stored procedures?

If I understand right, many Oracle applications limit
data access by users (thereby enhancing security) by
allowing data access only via procedures.

You appear to be saying that you like this feature,
and you want it to be available in PostgreSQL.

PostgreSQL has a different method of achieving the
same result, as has already been pointed out (views
with appropriate rewrite rules).  If there is not a
strong desire among PostgreSQL users for the feature
that you want, that is probably because the existing
method works well for them.

Remember that PostgreSQL is a project run and
developed by volunteers.  The strongest vote for a new
feature is the submission of code.  The developers are
not insensitive to the requests of users, but: if
development is left to them, don't be surprised that
they use their own judgement about what is most
important.

I have never seen anyone on this list say that Oracle
is not a good product.  If you want to use Oracle, and
you (or your customer) have the money to pay, then go
for it.

--- eric@datalink.nl wrote:
> On Tue, Feb 19, 2002 at 05:12:42PM +0100, Helge
> Bahmann wrote:
> > - if your data integrity and consistency
> constraints cannot easily be
> > expressed in relational terms, a relational
> database may not be the best
> > tool to solve your problem
>
> I don't see a real difference between a grant on a
> table, view or sequence and
> a procedure.  Grants have NOTHING to do at all with
> ANY of the relations in the
> database, so if this is your point of view the
> grants shouldn't exist AT ALL.
> But it seems that nody on this is willing to
> understand what I want or why I
> want it, so in one thing you are correct, PostgreSQL
> is definitely not the
> databse for me. It is useless to explain something
> to someone who simply
> doesn't want to understand you. It seems that I have
> to use a real database
> like Oracle after all.
>
> Signing off frm this mailinglist.
>
> --
> #!perl #                       Life ain't fair, but
> root passwords help.
> # Eric Veldhuyzen
> eric@terra.telemediair.nl
> $!=$;=$_+(++$_);($:,$~,$/,$^,$*,$@)=$!=~
>       # Perl Monger
> /.(.)...(.)(.)....(.)..(.)..(.)/;`$^$~$/$: $^$*$@$~
> $_>&$;`
>

> ATTACHMENT part 2 application/pgp-signature



__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com