Postgres Pro
Downloads
Home   >   mailing lists

Is there something like a limited superuser to give to a db-assistant? - Mailing list pgsql-general

From Andreas
Subject Is there something like a limited superuser to give to a db-assistant?
Date
Msg-id 5269CF0C.8030208@gmx.net
Whole thread Raw
Responses Re: Is there something like a limited superuser to give to a db-assistant?  ("Tomas Vondra" <tv@fuzzy.cz>)
Re: Is there something like a limited superuser to give to a db-assistant?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
Hi,

how can I give a db-assistant the rights to create and drop schemas, tables, views ... BUT keep him out of certain existing schemas and tables?

This position of an restricted db assistant is new for us and it wasn't considered in our access rights until now.

Our DB got a wee bit komplex with about 400 schemas and 5000 tables.
So it would get rather ugly having to alter the rights for every db-object one by one manually.

pgsql-general by date:

Previous
From: Andreas
Date:
Subject: Need help how to manage a couple of daily DB copies.
Next
From: "Tomas Vondra"
Date:
Subject: Re: Is there something like a limited superuser to give to a db-assistant?