hologres-privileges

Hologres access control uses PostgreSQL GRANT and REVOKE syntax to apply granular permissions. You can provision users, manage roles, and control schema, table, column, and view privileges directly.

Yes, you can set default privileges for future objects in Hologres schemas. This ensures that new tables and views automatically inherit defined access permissions for specific users or roles upon creation.

To diagnose Hologres permission issues and audit grants, you can run built-in diagnostic queries. These checks help identify incorrect access settings and verify current user privileges across database schemas.

Hologres supports USAGE, CREATE, and ALL privileges to secure multi-team analytics. You can map project roles to specific schema and table privileges to isolate team data access.

Yes, Hologres supports column-level GRANT and REVOKE permissions. This allows precise access control by restricting user queries to specific columns within a table while masking the rest.

Hologres default privileges apply only to future objects created by a specific user. Verify the GRANT default privileges target matches the object creator, and run diagnostic checks to audit current settings.