revoke usage on language plpythonu from username;
revoke usage on language plperl(u) from username;
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 26.07.2016 16:05, David G. Johnston wrote:
On Tue, Jul 26, 2016 at 8:53 AM, Dev Kumkar <devdas.kum...@gmail.com
<mailto:devdas.kum...@gmail.com>>wrote:
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.
