Обсуждение: Roles
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
Gambhir Singh
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
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
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/
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/