Skip to content

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

@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.

[email protected]:26257/demoapp/movr> create role can_bypassrls with bypassrls;
CREATE ROLE

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

[email protected]: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

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.2target-release-25.3.0

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions