Re: Roles

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Roles
Дата
Msg-id CANbhV-Fe=Z=kzHLC+THXv0Gm7RktgUNJh5o8=yvO6PML4vuG4w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Roles  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Roles
Список pgsql-general
Дерево обсуждения 
On Wed, 15 Sept 2021 at 00:11, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 9/14/21 1:13 PM, Gambhir Singh wrote:
> > Hi,
> >
> > I'm having 4 Databases in the AWS RDS Cluster. Just wanna to know how to
> > create roles which are specific to each database, because when I'm
> > creating roles in one Database, they are visible in other Databases.
>
> You can't, roles are global objects in a cluster.

Roles are global objects that are visible in all databases.

But you can GRANT the CONNECT privilege for a role to only specific databases.

-- 
Simon Riggs                http://www.EnterpriseDB.com/

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