Re: plpgsql by default
От | Joshua D. Drake |
---|---|
Тема | Re: plpgsql by default |
Дата | |
Msg-id | 1144796480.13511.26.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: plpgsql by default (Neil Conway <neilc@samurai.com>) |
Список | pgsql-hackers |
> That's a fair point. > > Perhaps a compromise would be to enable pl/pgsql by default, but not > grant the USAGE privilege on it. This would allow superusers to define > pl/pgsql functions without taking any additional steps. Non-superusers > could be given access to pl/pgsql via a simple GRANT -- either for all > users via GRANT TO PUBLIC, or on a more granular basis as desired. This > would lower the barrier to using pl/pgsql by a fairly significant > margin, but not cause any additional security exposure that I can see. That seems reasonable. Joshua D. Drake > > -Neil > > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/
В списке pgsql-hackers по дате отправления: