Roles and permissions

Postgres roles control who can access your database and what actions they can perform. Before users can connect to your database, you must create Postgres roles for them and grant appropriate permissions to access data.

note

Postgres roles control database access (who can query data). For project permissions (who can manage infrastructure), see Project permissions.

Set up database access

• • Manage Postgres roles
  • Create OAuth and password-based Postgres roles for database access.
• • Manage permissions
  • Grant database permissions to Postgres roles using SQL GRANT commands.
• • Transfer object ownership
  • Transfer ownership of tables and other Postgres objects to a Databricks group role.

Next steps

• Quickstart: Connect to your database
• Learn about authentication
• Tutorial: Grant project and database access to a new user