Integrate Oracle Access Governance with Database User Management (PostgreSQL)

Overview: Integrate Oracle Access Governance with Database User Management (PostgreSQL)

Integration between Oracle Access Governance and Database User Management (PostgreSQL) streamlines user lifecycle management of Database User Management (PostgreSQL) users, ensuring seamless access control and compliance through automated provisioning and enforcement of the principle of least privilege through reviews of users, roles, and privileges.

Database User Management (PostgreSQL) can be integrated with Oracle Access Governance as a managed system, allowing you to reconcile users, roles, and privileges, and provision identities and accounts.

Database User Management (PostgreSQL) Integration Architecture Overview

You can perform full data load for accounts in Database User Management (PostgreSQL). Once a connection is established, you can perform remediation and management tasks for user accounts, roles, and privileges.

Database User Management (PostgreSQL) integration supports management of Database User Management (PostgreSQL) accounts by Oracle Access Governance, including the following use cases.

  • Centralized User Provisioning:

    Perform Database User Management (PostgreSQL) user identity updates. Create, modify, and delete accounts from within Oracle Access Governance.

  • Access Control:

    Assign or revoke Database User Management (PostgreSQL) users, roles, and privileges using governance policies defined in Oracle Access Governance

    Automatically or manually revoke access for users whose access is no longer valid, based on organizational or lifecycle changes.

  • Segregation of Duties:

    Enforce segregation of duties (SoD) by implementing metadata-driven rules to define eligibility criteria for granting access bundle permissions, using Oracle Access Governance Access Guardrails

  • Self-Service Profile Management:

    Enable users to view and update their own profile attributes using Oracle Access Governance, with updates reflected in Database User Management (PostgreSQL).

  • Access Reviews and Attestation:

    Periodically review and certify Database User Management (PostgreSQL) user access to ensure appropriate entitlements.

  • Audit and Compliance Support:

    Maintain full audit logs of all user and access-related changes to meet regulatory and internal compliance requirements.

Functional Overview: Use Cases Supported for Database User Management (PostgreSQL) Integration

Database User Management (PostgreSQL) integration supports management of Database User Management (PostgreSQL) accounts by Oracle Access Governance, including the following use cases.