From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
To: | Eric Veldhuyzen <eric(at)terra(dot)telemediair(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: execute permissions of stored procedures? |
Date: | 2002-02-21 21:27:55 |
Message-ID: | m3r8ne7cf8.fsf@varsoon.denali.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Eric Veldhuyzen <eric(at)terra(dot)telemediair(dot)nl> writes:
> I want to use PostgreSQL as a database for our dynamic website, and
> the only thing I want to allow to the standard 'webuser' is to
> execute some procedures. The use of a grant to a procedure allows
> me to be able to insert/update some specific rows in a database in a
> very specific way by a user that normally wouldn't even be allowed
> to do a SELECT on this table.
This seems to be a repeat of your previous message (perhaps there's a
mail loop somewhere) so I won't rehash the discussions we've had.
I'll just point out that SQL schemas and all that they imply are
coming in 7.3, so you may want to reevaluate PostgreSQL for your needs
at that point (it'll be a while though as 7.3 development has just
started).
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Marzen | 2002-02-21 21:28:44 | Re: Perl or PHP DB Access? |
Previous Message | Ulrich Wisser | 2002-02-21 21:26:42 | Re: Protection of intellectual property (Schema & |