Core Features
Privileges
Privileges help teams manage database access safely. In Dory, privilege-related workflows are most relevant for ClickHouse and other databases where Dory can inspect users, roles, and permissions.
What You Can Do
- Inspect users and roles.
- Review granted privileges.
- Understand who can access which databases or tables.
- Support access review and operational troubleshooting.
- Coordinate safer cluster or production operations.
User Management
Review database users, their purpose, and whether they have more access than needed.
Role Management
Use roles to group permissions by responsibility, environment, or workload.
Permission Details
Inspect grants to understand what a user or role can read, write, administer, or modify.
Cluster Operations
For ClickHouse clusters, privilege review can support safer operations across nodes and environments when the connected user has permission.
Security Recommendations
- Prefer read-only accounts for analysis.
- Avoid sharing administrator credentials.
- Separate production, staging, and local access.
- Review grants before enabling team-wide access.
- Keep AI-assisted workflows on least-privilege connections.