Just-in-Time Access To PostgreSQL

Apono empowers you to craft dynamic Access Flows, providing on-demand permissions with meticulous granularity and comprehensive audit capabilities.

Note: You can also choose to integrate RDS, CloudSQL, or Azure SQL

Just-inTime
(JIT)

PostgreSQL, often referred to as “Postgres,” is an open-source relational database management system (RDBMS). It is known for its advanced features, extensibility, and adherence to SQL standards. PostgreSQL supports a wide range of data types and has a reputation for being a powerful and robust database solution.

Just-In-Time (JIT) access involves assigning permissions to users or systems in real-time as needed, rather than maintaining continuous access. This strategy is frequently employed in cybersecurity to reduce the risk of security breaches by restricting unnecessary access. It aligns with the principle of least privilege (POLP), emphasizing that users should only have the minimum access levels required to fulfill their tasks.

AWS Use Cases

Just-In-Time Access to Production Database

Allow SREs, Developers or Platform Engineers to receive temporary granular permissions to collections and databases.
“BreakGlass”, “Firefighter” role, and On-Call access automation with integration to PagerDuty and more shift management and incident response tools.
Contractor or Third-Party Restricted Temporary access granting with MFA.

When

Dev

requests

READ/WRITE

Postgres_Prod

from

Postgres_AWS

grant access for

3 hours

with

Dev_ops

approval

Compliant Customer Database Access

Grant permissions to only the specific customer data across multitenant databases and with customer consent.
Satisfy customer security requirements with granular access control and full audit of access to customer databases.
Easily restrict access to PII, PHI, PCI and any regulated or sensitive data access.

When

DEV

requests

READ/WRITE

Postgres_Prod

from

Postgres_AWS

grant access for

2 hours

with

Customer

approval

Prevent Human Errors in Production

Dynamically grant only the permissions needed for the task at hand to prevent costly mistakes in production and downtime.

When

Dev

requests

WRITE

Postgres_Prod

from

Postgres_AWS

grant access for

1 hour

with

DevOps

approval

Benefits

Comprehensive Audit Log

Enhance PostgreSQL access and permissions transparency, facilitating comprehensive auditing for incident investigation and the implementation of scheduled reporting mechanisms to meet compliance requirements effectively.

Automating Access and Permissions to PostgreSQL

Automate Self-Serviceable permissions to PostgreSQL database or schemas directly from Slack, Teams or from your CLI.

Granular PostgreSQL Database Access

Define PostgreSQL database and schema permissions as fine-grained as necessary.

Comprehensive Audit Log

Automated Database Permissions Approval Workflows

Define access approval workflow based on defined organizational permission guardrails.

Restricted Third-Party Access

Grant third-party (customer or vendor) time-based access to specific buckets, databases or instances with MFA verification.

Self-Serve Permissions

Self-serve permissions to PostgreSQL database or collections directly from Slack, Teams or from your CLI.

Break-Glass Scenarios

Equip first-responders with the capability to access permissions on demand, while concurrently capturing essential incident context, details of granted access, and the chronological timeline of events.

Decreased Insider Threats

The implementation of just-in-time privilege escalation serves to mitigate internal threats by ensuring that personnel are granted access to sensitive information or specific operational capabilities only when essential. This precautionary measure helps prevent unauthorized or unintentional data access.