Restrict allowed database names?
От | Adam Seering |
---|---|
Тема | Restrict allowed database names? |
Дата | |
Msg-id | F84CC8A4-0BBE-409D-B1DD-13C50D4515EA@mit.edu обсуждение исходный текст |
Ответы |
Re: Restrict allowed database names?
Re: Restrict allowed database names? Re: Restrict allowed database names? |
Список | pgsql-general |
Hi, I'm trying to set up an internal general-purpose PostgreSQL server installation. I want most users with login accessto 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 withany name. The goal is to let users create arbitrary databases, but to force them to get approval for names that someoneelse (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
В списке pgsql-general по дате отправления: