Re: which database to login to to create global users?

Поиск
Список
Период
Сортировка
От pres
Тема Re: which database to login to to create global users?
Дата
Msg-id c465caf0601031214j2efd61b2w9a60ec7fd70214e1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: which database to login to to create global users?  (Jaime Casanova <systemguards@gmail.com>)
Ответы Re: which database to login to to create global users?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Дерево обсуждения
hello jaime,

roles are always global... i don't think you can create roles that
exist just in one database...

you assign permissions to roles via the GRANT statement...

that's a little surprising, but definitely good to know!

so, if i understand you correctly, it does not matter which database i'm logged into when i create a role?

where (what database/table), then, are theses assignments stored?

i've clearly misunderstood how these work, i think.

thanks,

pres

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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: which database to login to to create global users?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: which database to login to to create global users?