---
title: pg_authid
page-cloud: true
latest-operator-version: v26.2.6
latest-console-tag: v3.14.0
latest-connect-version: 4.118.0
latest-redpanda-tag: v26.2.7
docname: sql/system-catalogs/catalogs/pg_authid
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_authid.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_authid.adoc
description: The pg_authid system catalog stores information about database authorization identifiers (roles).
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
page-generated-content: none
---

# pg_authid

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_authid.md -->

The `pg_authid` system catalog stores information about database authorization identifiers (roles). It mimics the [pg_authid](https://www.postgresql.org/docs/current/catalog-pg-authid.html) PostgreSQL system catalog.

> 📝 **NOTE**
>
> This table is only accessible to superusers. For a publicly readable view of role information, use [pg_roles](https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_roles/).

## Columns

The following columns are available for querying in `pg_authid`:

| Column | Type | Description |
| --- | --- | --- |
| `oid` | `bigint` | Object identifier for the role |
| `rolname` | `text` | Role name |
| `rolsuper` | `bool` | Whether the role has superuser privileges |
| `rolinherit` | `bool` | Whether the role inherits privileges of roles it is a member of |
| `rolcreaterole` | `bool` | Whether the role can create other roles |
| `rolcreatedb` | `bool` | Whether the role can create databases |
| `rolcanlogin` | `bool` | Whether the role can log in |
| `rolreplication` | `bool` | Whether the role has replication privileges |
| `rolbypassrls` | `bool` | Whether the role bypasses row-level security policies |
| `rolconnlimit` | `int` | Connection limit for the role (`-1` means no limit) |
| `rolpassword` | `text` | Encrypted password |
| `rolvaliduntil` | `timestamptz` | Password expiration time (NULL if no expiration) |

## Examples

```sql
SELECT rolname, rolsuper, rolcanlogin FROM pg_authid;
```