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?
Thanks,
Adam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
