| From: | Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Roles |
| Date: | 2021-09-15 18:04:03 |
| Message-ID: | CAHOGQfVJUmd7aJ52U=K=Oo5-SJb72SMSr=gmY3oow3ygcraBSw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks alot
On Wed, 15 Sep 2021, 07:36 Simon Riggs, <simon(dot)riggs(at)enterprisedb(dot)com>
wrote:
> 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 | Ron | 2021-09-15 18:07:33 | Re: Alter and move corresponding: was The tragedy of SQL |
| Previous Message | Michael Nolan | 2021-09-15 17:47:38 | Re: Alter and move corresponding: was The tragedy of SQL |