Postgres Pro
Downloads
Home   >   mailing lists

Re: How non-superuser can restore database containing procedures - Mailing list pgsql-general

From Tom Lane
Subject Re: How non-superuser can restore database containing procedures
Date
Msg-id 9049.1166456829@sss.pgh.pa.us
Whole thread Raw
In response to Re: How non-superuser can restore database containing procedures  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Richard Huxton <dev@archonet.com> writes:
> Andrus wrote:
>> How to allow non-superusres to create database with language ?

> You can't. If they can install a language-handler, they can install code
> that can do anything, including take control of the server and the unix
> account it runs as.

However, you could install the desired languages into template1, or
perhaps better make an extra template database containing them.
Then CREATE DATABASE could copy them into new databases.

            regards, tom lane

pgsql-general by date:

Previous
From: Derrick Stensrud
Date:
Subject: pam ldap postgres troubles cannot get postgres to auth via ldap
Next
From: "Tomi N/A"
Date:
Subject: Re: permission in the db or in the application?