New to postgresql - Do I have to be a "superuser" to be able to create a database?
От | gromitracer |
---|---|
Тема | New to postgresql - Do I have to be a "superuser" to be able to create a database? |
Дата | |
Msg-id | 1388979158012-5785428.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: New to postgresql - Do I have to be a "superuser" to be
able to create a database?
Re: New to postgresql - Do I have to be a "superuser" to be able to create a database? |
Список | pgsql-general |
Hello all. I am more accustomed in doing things the Oracle way and I am trying to get a hold postgres :) Below are my roles/users and their attributes. Posgresql version: 9.2 Role name | Attributes | Member of ---------------+-------------------------------------------------------------------------------+---------------- devs | Create DB, Cannot login | {} batman | | {devs} postgres | Superuser, Create role, Create DB, Replication | {} As you can see: role: DEVS is configured to be able to create a database. user: batman is member of DEVS However, when I login as batman and I issue the command "CREATE DATABASE metropolis;" I get a Permission denied. Even when I give DEVS a "superuser" attribute, user batman still cannot create a database. Do I have to elevate user batman to a superuser? Isn't that dangerous when it comes to security? Thank you :) -- View this message in context: http://postgresql.1045698.n5.nabble.com/New-to-postgresql-Do-I-have-to-be-a-superuser-to-be-able-to-create-a-database-tp5785428.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: