Thread

1. Roles

   Gambhir Singh <gambhir.singh05@gmail.com> — 2021-09-14T20:13:15Z

   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
   

2. Re: Roles

   Adrian Klaver <adrian.klaver@aklaver.com> — 2021-09-14T23:11:45Z

   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.klaver@aklaver.com
   
   
   
   

3. Re: Roles

   Gambhir Singh <gambhir.singh05@gmail.com> — 2021-09-15T03:25:55Z

   Thank you for the clarification.
   
   On Tue, 14 Sep 2021, 18: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.
   >
   > >
   > > Thanks & Regards
   > > Gambhir Singh
   > >
   >
   >
   > --
   > Adrian Klaver
   > adrian.klaver@aklaver.com
   >
   

4. Re: Roles

   Simon Riggs <simon.riggs@enterprisedb.com> — 2021-09-15T12:36:45Z

   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/
   
   
   
   

5. Re: Roles

   Gambhir Singh <gambhir.singh05@gmail.com> — 2021-09-15T18:04:03Z

   Thanks alot
   
   On Wed, 15 Sep 2021, 07:36 Simon Riggs, <simon.riggs@enterprisedb.com>
   wrote:
   
   > 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/
   >