Re: Question About Roles

Поиск
Список
Период
Сортировка
От Gregory Haase
Тема Re: Question About Roles
Дата
Msg-id CAHA6QFQKJc6FYWHSc0a1G4yckiLRh=UtK9y=ARCfZ2QA1s5R4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question About Roles  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Question About Roles  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general



On Wed, Jul 2, 2014 at 7:50 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Wed, 2 Jul 2014, David G Johnston wrote:

or if you want to do it as part of creating a new user:

CREATE ROLE new_management_user
[other stuff here]
IN ROLE management;

http://www.postgresql.org/docs/9.2/interactive/sql-createrole.html

David,

  I'll have to think deeply about what this is doing. Initially, I read it
as assigning a new user's role to an existing group's role; that's the
opposite of what I want.

Thanks,

Rich


If it made you feel better, remember that CREATE USER is an alias for CREATE ROLE that includes LOGIN by default. So if you simply swap one word in your command, the context becomes a little more clear for what you want:

CREATE USER new_management_user
[other stuff here]
IN ROLE management;  


-Greg Haase

В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Question About Roles
Следующее
От: sunpeng
Дата:
Сообщение: Re: Migration error " invalid byte sequence for encoding "UTF8": 0xff " from mysql 5.5 to postgresql 9.1