Roles

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 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: