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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: WAL archive cleanup om master
Следующее
От: Shuwn Yuan Tee
Дата:
Сообщение: postgres_fdw foreign table performance Issue