Re: How to stop script executions
| От | David G. Johnston |
|---|---|
| Тема | Re: How to stop script executions |
| Дата | |
| Msg-id | CAKFQuwYb_s3f-WTVbjrMrjhH_YQ0e=cB7HCGnaxF4J4LDegGVw@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to stop script executions (Dev Kumkar <devdas.kumkar@gmail.com>) |
| Ответы |
Re: How to stop script executions
Re: How to stop script executions |
| Список | pgsql-general |
Hello Experts,I want to have my postgreSQL database to only execute SQLs and avoid execution of perl and python script executions.Can you please suggest ways to achieve this?
The way to go about prohibiting their usage altogether is specific to your installation method. But by default those languages are not installed into newly created databases and only a superuser can "CREATE EXTENSION" so without superuser intervention uses in the database will be unable to create functions in those languages. If that is an insufficient level of prevention you would have to somehow get your installation of PostgreSQL to not include those core extensions. I'm pretty sure that during compilation you can do this. For packaged distributions I do not know what all is involved (i.e., what you have to choose to not install).
David J.
В списке pgsql-general по дате отправления: