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 по дате отправления: