Roles

[Gambhir Singh]

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.

Thanks & Regards
Gambhir Singh

Re: Roles

[Gambhir Singh]

Thank you for the clarification.

On Tue, 14 Sep 2021, 18:11 Adrian Klaver,  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.
>
> >
> > Thanks & Regards
> > Gambhir Singh
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Re: Roles

[Gambhir Singh]

Thanks alot

On Wed, 15 Sep 2021, 07:36 Simon Riggs, 
wrote:

> On Wed, 15 Sept 2021 at 00:11, Adrian Klaver 
> 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 Riggshttp://www.EnterpriseDB.com/
>