Delegating User creation
От | Tom Jenkins |
---|---|
Тема | Delegating User creation |
Дата | |
Msg-id | 3B584DAE.4080003@devis.com обсуждение исходный текст |
Ответы |
Re: Delegating User creation
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: