On 21 March 2010 00:24, Adam Seering <aseer...@mit.edu> wrote: > Hi, > I'm trying to set up an internal general-purpose PostgreSQL server > installation. I want most users with login access to the server to be able > to create databases, but only with names that follow a specified naming > convention (in particular, approximately "is prefixed with the owner's > username"). A subset of administrative users can create users with any name. > The goal is to let users create arbitrary databases, but to force them to > get approval for names that someone else (or some other service) might > conceivably want. > > Is there any way to enforce this within PostgreSQL? Maybe something > like a trigger on CREATE DATABASE, if that's possible? >
What about PL/pgSQL wrapper function for CREATE DATABASE with database name check and SECURITY DEFINER option. And of course you should not set CREATEDB option to regular users. -- Regards, Sergey Konoplev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
