Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitc7cf9a2

Browse files
committed
Add usebypassrls to pg_user and pg_shadow
The row level security patches didn't add the 'usebypassrls' columns tothe pg_user and pg_shadow views on the belief that they were deprecated,but we havn't actually said they are and therefore we should include it.This patch corrects that, adds missing documentation for rolbypassrlsinto the system catalog page for pg_authid, along with the entries forpg_user and pg_shadow, and cleans up a few other uses of 'row-level'cases to be 'row level' in the docs.Pointed out by Amit Kapila.Catalog version bump due to system view changes.
1 parentf8519a6 commitc7cf9a2

File tree

4 files changed

+36
-3
lines changed

4 files changed

+36
-3
lines changed

‎doc/src/sgml/catalogs.sgml

Lines changed: 31 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1444,6 +1444,15 @@
14441444
</entry>
14451445
</row>
14461446

1447+
<row>
1448+
<entry><structfield>rolbypassrls</structfield></entry>
1449+
<entry><type>bool</type></entry>
1450+
<entry>
1451+
Role can bypass row level security policies, see
1452+
<xref linkend="ddl-rowsecurity"> for more information.
1453+
</entry>
1454+
</row>
1455+
14471456
<row>
14481457
<entry><structfield>rolconnlimit</structfield></entry>
14491458
<entry><type>int4</type></entry>
@@ -1951,7 +1960,7 @@
19511960
<entry><type>bool</type></entry>
19521961
<entry></entry>
19531962
<entry>
1954-
True if table has row-level security enabled; see
1963+
True if table has rowlevel security enabled; see
19551964
<link linkend="catalog-pg-policy"><structname>pg_policy</structname></link> catalog
19561965
</entry>
19571966
</row>
@@ -4719,7 +4728,7 @@
47194728
</indexterm>
47204729

47214730
<para>
4722-
The catalog <structname>pg_policy</structname> stores row-level
4731+
The catalog <structname>pg_policy</structname> stores rowlevel
47234732
security policies for tables. A policy includes the kind of
47244733
command that it applies to (possibly all commands), the roles that it
47254734
applies to, the expression to be added as a security-barrier
@@ -9030,6 +9039,16 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
90309039
</entry>
90319040
</row>
90329041

9042+
<row>
9043+
<entry><structfield>usebypassrls</structfield></entry>
9044+
<entry><type>bool</type></entry>
9045+
<entry></entry>
9046+
<entry>
9047+
User can bypass row level security policies, see
9048+
<xref linkend="ddl-rowsecurity"> for more information.
9049+
</entry>
9050+
</row>
9051+
90339052
<row>
90349053
<entry><structfield>passwd</structfield></entry>
90359054
<entry><type>text</type></entry>
@@ -9505,6 +9524,16 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
95059524
</entry>
95069525
</row>
95079526

9527+
<row>
9528+
<entry><structfield>usebypassrls</structfield></entry>
9529+
<entry><type>bool</type></entry>
9530+
<entry></entry>
9531+
<entry>
9532+
User can bypass row level security policies, see
9533+
<xref linkend="ddl-rowsecurity"> for more information.
9534+
</entry>
9535+
</row>
9536+
95089537
<row>
95099538
<entry><structfield>passwd</structfield></entry>
95109539
<entry><type>text</type></entry>

‎src/backend/catalog/system_views.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -33,6 +33,7 @@ CREATE VIEW pg_shadow AS
3333
rolsuperAS usesuper,
3434
rolcatupdateAS usecatupd,
3535
rolreplicationAS userepl,
36+
rolbypassrlsAS usebypassrls,
3637
rolpasswordAS passwd,
3738
rolvaliduntil::abstimeAS valuntil,
3839
setconfigAS useconfig
@@ -58,6 +59,7 @@ CREATE VIEW pg_user AS
5859
usesuper,
5960
usecatupd,
6061
userepl,
62+
usebypassrls,
6163
'********'::textas passwd,
6264
valuntil,
6365
useconfig

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201501241
56+
#defineCATALOG_VERSION_NO201501281
5757

5858
#endif

‎src/test/regress/expected/rules.out

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1609,6 +1609,7 @@ pg_shadow| SELECT pg_authid.rolname AS usename,
16091609
pg_authid.rolsuper AS usesuper,
16101610
pg_authid.rolcatupdate AS usecatupd,
16111611
pg_authid.rolreplication AS userepl,
1612+
pg_authid.rolbypassrls AS usebypassrls,
16121613
pg_authid.rolpassword AS passwd,
16131614
(pg_authid.rolvaliduntil)::abstime AS valuntil,
16141615
s.setconfig AS useconfig
@@ -2063,6 +2064,7 @@ pg_user| SELECT pg_shadow.usename,
20632064
pg_shadow.usesuper,
20642065
pg_shadow.usecatupd,
20652066
pg_shadow.userepl,
2067+
pg_shadow.usebypassrls,
20662068
'********'::text AS passwd,
20672069
pg_shadow.valuntil,
20682070
pg_shadow.useconfig

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp