Re: execute permissions of stored procedures?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: execute permissions of stored procedures?
Дата
Msg-id m3r8ne7cf8.fsf@varsoon.denali.to
обсуждение исходный текст
Ответ на execute permissions of stored procedures?  (Eric Veldhuyzen <eric@terra.telemediair.nl>)
Список pgsql-general
Eric Veldhuyzen <eric@terra.telemediair.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: deleting an identical record
Следующее
От: Ulrich Wisser
Дата:
Сообщение: Re: Protection of intellectual property (Schema &