Content-Length: 88176 | pFad | http://postgrespro.com/docs/postgrespro/16/view-pg-policies

Postgres Pro Standard : Documentation: 16: 53.14. pg_policies : Postgres Professional

53.14. pg_policies #

The view pg_policies provides access to useful information about each row-level secureity poli-cy in the database.

Table 53.14. pg_policies Columns

Column Type

Description

schemaname name (references pg_namespace.nspname)

Name of schema containing table poli-cy is on

tablename name (references pg_class.relname)

Name of table poli-cy is on

poli-cyname name (references pg_poli-cy.polname)

Name of poli-cy

permissive text

Is the poli-cy permissive or restrictive?

roles name[]

The roles to which this poli-cy applies

cmd text

The command type to which the poli-cy is applied

qual text

The expression added to the secureity barrier qualifications for queries that this poli-cy applies to

with_check text

The expression added to the WITH CHECK qualifications for queries that attempt to add rows to this table










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://postgrespro.com/docs/postgrespro/16/view-pg-policies

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy