Hello all,
I've looked at the mailing list archives but didn't see anything related
to my question. Last night at our LUG meeting I gave a brief talk on
how we use PostgreSQL for our clients. Afterward I was asked a question
that I couldn't answer. So I was hoping someone here could answer or
help out.
Some staff members at local university are running a PostgreSQL
installation with a number of databases. The (part-time) admin would
like to delegate user creation to selected people in the various
departments. However it looks like to give those folks user creation
rights, they would become super users and be able to access other
departments' databases. Is there a way for a user to get user creation
rights only for their database and not get superuser rights across all
databases?
(they're considering switching to MySQL which they believe they can do
this; I don't/haven't uses MySQL so cannot confirm that is so.)
Thanks.
--
Tom Jenkins
devIS - Development Infostructure
http://www.devis.com
