Postgres User wrote:
Does anyone have a recommendation for maintaining user permissions on
a changing database? The lack of an option to grant specific rights
to all objects of a given type within a Postgres db obviously places
the burden on the administrator to keep roles updated as objects are
added and dropped from a given database.
Unfortunately for us, we don't have a dedicated db admin, so this task
falls into the hands of developers who are probably less adapt at this
kind of task ;)
Is there a utility or set of scripts out there that helps a db owner
with permissions admin?
your question is just too vague to even begin to know what it is you want ?
there are scripts for GRANTALL like functionality. But, if you use
nested roles for your permissions, these things just don't come up.
Or if the database is owned by the account that creates the tables and
accesses it, again, they don't come up at all.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
