> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# CockroachDB Security Overview
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
## Comparison of security features
| Security Domain | CockroachDB Basic | CockroachDB Standard | CockroachDB Advanced | CockroachDB self-hosted Enterprise | Feature |
| --------------------------------------------------------------------------------------- | ----------------- | -------------------- | -------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Authentication | ✓ | ✓ | ✓ | ✓ | Inter-node and node identity authentication using TLS 1.3 |
| ✓ | ✓ | ✓ | ✓ | Client identity authentication using username/password | |
| ✓ | ✓ | ✓ | ✓ | SASL/SCRAM-SHA-256 secure password-based authentication | |
| | | | ✓ | SQL client identity authentication using TLS 1.2/1.3 | |
| ✓ | ✓ | ✓ | ✓ | Web console authentication with third-party Single Sign-on (SSO) using [OpenID Connect OIDC](https://openid.net/connect) | |
| | | ✓ | ✓ | SQL client identity authentication with JSON Web Tokens (JWT) | |
| | | | ✓ | Client identity authentication with GSSAPI and Kerberos | |
| | | ✓ | ✓ | Automatic user provisioning for JWT authentication | |
| | | ✓ | ✓ | Automatic user provisioning for OIDC authentication | |
| | | | ✓ | HTTP API access using login tokens | |
| | | | ✓ | [OCSP](https://wikipedia.org/wiki/Online_Certificate_Status_Protocol) certificate revocation protocol | |
| Encryption | ✓ | ✓ | ✓ | ✓ | Encryption in transit using TLS 1.3 |
| ✓ | ✓ | ✓ | ✓ | Backups for AWS clusters are encrypted at rest using [AWS S3’s server-side encryption](https://docs.aws.amazon.com/AmazonS3/latest/dev/UsingServerSideEncryption) | |
| ✓ | ✓ | ✓ | ✓ | Backups for GCP clusters are encrypted at rest using [Google-managed server-side encryption keys](https://cloud.google.com/storage/docs/encryption/default-keys) | |
| ✓ | ✓ | ✓ | ✓ | Industry-standard encryption at rest is provided at the infrastructure level by your chosen deployment environment, such as Google Cloud Platform (GCP), Amazon Web Services (AWS), or Microsoft Azure. You can learn more about [GCP persistent disk encryption](https://cloud.google.com/compute/docs/disks#pd_encryption), [AWS Elastic Block Storage](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSEncryption), or [Azure managed disk encryption](https://docs.microsoft.com/azure/virtual-machines/disk-encryption-overview). | |
| | | | ✓ | Cockroach Labs's proprietary storage-level Enterprise Encryption At Rest service implementing the [Advanced Encryption Standard (AES)](https://wikipedia.org/wiki/Advanced_Encryption_Standard) | |
| Authorization | ✓ | ✓ | ✓ | ✓ | Users and privileges |
| ✓ | ✓ | ✓ | ✓ | Role-based access control (RBAC) | |
| | | ✓ | ✓ | Automatic role synchronization based on JWT group claims | |
| | | ✓ | ✓ | Automatic role synchronization based on OIDC group claims for DB Console | |
| Network Security | ✓ | ✓ | ✓ | ✓ | SQL-level configuration allowed authentication attempts by IP address |
| ✓ | ✓ | ✓ | ✓ | Network-level Configuration of allowed IP addresses | |
| | ✓ | ✓ | ✓ | GCP Private Service Connect (PSC) (Preview) or VPC Peering for GCP clusters and AWS PrivateLink for AWS clusters | |
| [Non-Repudiation](https://wikipedia.org/wiki/Non-repudiation) | ✓ | ✓ | ✓ | ✓ | SQL Audit Logging |
| Availability/Resilience | ✓ | ✓ | ✓ | ✓ | CockroachDB, as a distributed SQL database, is uniquely resilient by nature. A cluster can tolerate node failures as long as the majority of nodes remain functional. See Disaster Recovery. |