| From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Roles |
| Date: | 2021-09-15 12:36:45 |
| Message-ID: | CANbhV-Fe=Z=kzHLC+THXv0Gm7RktgUNJh5o8=yvO6PML4vuG4w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 15 Sept 2021 at 00:11, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2021-09-15 13:01:19 | Re: SQL queries as sets: was The tragedy of SQL |
| Previous Message | Tom Lane | 2021-09-15 11:56:21 | Re: Basic Questions about PostgreSQL. |