Authentication & Roles

Authentication & Roles

Connection format, TLS, and role-based access control.

Connecting

Connect using the standard PostgreSQL connection string format:

Terminal

psql "postgresql://<db_id>.<user>:<password>@pg.db9.io:5433/postgres"

All connections use TLS (sslmode=require).

RBAC

• CREATE ROLE / ALTER ROLE
• GRANT / REVOKE privileges on tables and schemas
• SET ROLE for session role switching
• Privilege checks enforced on every table access

Coming Soon

Detailed RBAC documentation with permission matrices and examples is in progress.