risingwave_frontend/catalog/system_catalog/pg_catalog/
pg_roles.rs

1// Copyright 2025 RisingWave Labs
2//
3// Licensed under the Apache License, Version 2.0 (the "License");
4// you may not use this file except in compliance with the License.
5// You may obtain a copy of the License at
6//
7//     http://www.apache.org/licenses/LICENSE-2.0
8//
9// Unless required by applicable law or agreed to in writing, software
10// distributed under the License is distributed on an "AS IS" BASIS,
11// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12// See the License for the specific language governing permissions and
13// limitations under the License.
14
15use risingwave_common::types::{Fields, Timestamptz};
16use risingwave_frontend_macro::system_catalog;
17
18/// The catalog `pg_roles` provides access to information about database roles. This is simply a
19/// publicly readable view of `pg_authid` that blanks out the password field.
20/// Ref: [`https://www.postgresql.org/docs/current/view-pg-roles.html`]
21#[system_catalog(
22    view,
23    "pg_catalog.pg_roles",
24    "SELECT id AS oid,
25        name AS rolname,
26        is_super AS rolsuper,
27        true AS rolinherit,
28        create_user AS rolcreaterole,
29        create_db AS rolcreatedb,
30        can_login AS rolcanlogin,
31        true AS rolreplication,
32        -1 AS rolconnlimit,
33        NULL::timestamptz AS rolvaliduntil,
34        true AS rolbypassrls,
35        '********' AS rolpassword
36    FROM rw_catalog.rw_users"
37)]
38#[derive(Fields)]
39struct PgRule {
40    oid: i32,
41    rolname: String,
42    rolsuper: bool,
43    rolinherit: bool,
44    rolcreaterole: bool,
45    rolcreatedb: bool,
46    rolcanlogin: bool,
47    rolreplication: bool,
48    rolconnlimit: i32,
49    rolvaliduntil: Timestamptz,
50    rolbypassrls: bool,
51    rolpassword: String,
52}
risingwave_frontend/catalog/system_catalog/pg_catalog/pg_roles.rs

risingwave_frontend/catalog/system_catalog/pg_catalog/
pg_roles.rs
