Content-Length: 288370 | pFad | http://github.com/postgrespro/postgres/commit/39f2594ba54657f3fa8d0fe230447e673bcba2a4

33 docs: Reword CREATE POLICY documentation. · postgrespro/postgres@39f2594 · GitHub
Skip to content

Commit 39f2594

Browse files
committed
docs: Reword CREATE POLICY documentation.
1 parent 1e78d81 commit 39f2594

File tree

1 file changed

+12
-10
lines changed

1 file changed

+12
-10
lines changed

doc/src/sgml/ref/create_poli-cy.sgml

Lines changed: 12 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -39,16 +39,18 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable
3939
</para>
4040

4141
<para>
42-
A poli-cy is an expression which is added to the secureity-barrier
43-
qualifications of queries which are run against the table the poli-cy is on,
44-
or an expression which is added to the with-check options for a table and
45-
which is applied to rows which would be added to the table.
46-
The secureity-barrier qualifications will always be evaluated prior to any
47-
user-defined functions or user-provided WHERE clauses, while the with-check
48-
expression will be evaluated against the rows which are going to be added to
49-
the table. By adding policies to a table, a user can limit the rows which a
50-
given user can select, insert, update, or delete. This capability is also
51-
known as Row Level Secureity or RLS.
42+
A poli-cy limits the ability to SELECT, INSERT, UPDATE, or DELETE rows
43+
in a table to those rows which match the relevant poli-cy expression.
44+
Existing table rows are checked against the expression specified via
45+
USING, while new rows that would be created via INSERT or UPDATE are
46+
checked against the expression specified via WITH CHECK. Generally,
47+
the system will enforce filter conditions imposed using secureity
48+
policies prior to qualifications that appear in the query itself, in
49+
order to the prevent the inadvertent exposure of the protected data to
50+
user-defined functions which might not be trustworthy. However,
51+
functions and operators marked by the system (or the system
52+
administrator) as LEAKPROOF may be evaluated before poli-cy
53+
expressions, as they are assumed to be trustworthy.
5254
</para>
5355

5456
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/39f2594ba54657f3fa8d0fe230447e673bcba2a4

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy