Skip to content

sql/rls: rolbypassrls in pg_roles is always false #146228

Open
@spilchen

Description

@spilchen

The vtable pg_roles currently always fills in false for the column rolbypassrls. Now that we have implemented the BYPASSRLS role option, we can properly fill in this column now.

root@127.0.0.1:26257/demoapp/movr> create role can_bypassrls with bypassrls;
CREATE ROLE

Time: 58ms total (execution 58ms / network 0ms)

root@127.0.0.1:26257/demoapp/movr> SELECT rolbypassrls from pg_roles where rolname = 'can_bypassrls';
  rolbypassrls
----------------
       f
(1 row)

Time: 6ms total (execution 5ms / network 0ms)

Jira issue: CRDB-50438

Epic CRDB-48807

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-release-25.2

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions