8000 Add information schema views role_udt_grants, udt_privileges, user_de… · postgrespro/postgres@d34e142 · GitHub
[go: up one dir, main page]
Skip to content

Commit d34e142

Browse files
peterepetere
committed
Add information schema views role_udt_grants, udt_privileges, user_defined_types
1 parent 2c262ea commit d34e142

File tree

2 files changed

+442
-8
lines changed

2 files changed

+442
-8
lines changed

‎doc/src/sgml/information_schema.sgml

Lines changed: 367 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3509,6 +3509,81 @@ ORDER BY c.ordinal_position;
35093509
</table>
35103510
</sect1>
35113511

3512+
<sect1 id="infoschema-role-udt-grants">
3513+
<title><literal>role_udt_grants</literal></title>
3514+
3515+
<para>
3516+
The view <literal>role_udt_grants</literal> is intended to identify
3517+
<literal>USAGE</literal> privileges granted on user-defined types
3518+
where the grantor or grantee is a currently enabled role. Further
3519+
information can be found under
3520+
<literal>udt_privileges</literal>. The only effective difference
3521+
between this view and <literal>udt_privileges</literal> is that
3522+
this view omits objects that have been made accessible to the
3523+
current user by way of a grant to <literal>PUBLIC</literal>. Since
3524+
data types do not have real privileges in PostgreSQL, but only an
3525+
implicit grant to <literal>PUBLIC</literal>, this view is empty.
3526+
</para>
3527+
3528+
<table>
3529+
<title><literal>role_udt_grants</literal> Columns</title>
3530+
3531+
<tgroup cols="3">
3532+
<thead>
3533+
<row>
3534+
<entry>Name</entry>
3535+
<entry>Data Type</entry>
3536+
<entry>Description</entry>
3537+
</row>
3538+
</thead>
3539+
3540+
<tbody>
3541+
<row>
3542+
<entry><literal>grantor</literal></entry>
3543+
<entry><type>sql_identifier</type></entry>
3544+
<entry>The name of the role that granted the privilege</entry>
3545+
</row>
3546+
3547+
<row>
3548+
<entry><literal>grantee</literal></entry>
3549+
<entry><type>sql_identifier</type></entry>
3550+
<entry>The name of the role that the privilege was granted to</entry>
3551+
</row>
3552+
3553+
<row>
3554+
<entry><literal>udt_catalog</literal></entry>
3555+
<entry><type>sql_identifier</type></entry>
3556+
<entry>Name of the database containing the type (always the current database)</entry>
3557+
</row>
3558+
3559+
<row>
3560+
<entry><literal>udt_schema</literal></entry>
3561+
<entry><type>sql_identifier</type></entry>
3562+
<entry>Name of the schema containing the type</entry>
3563+
</row>
3564+
3565+
<row>
3566+
<entry><literal>udt_name</literal></entry>
3567+
<entry><type>sql_identifier</type></entry>
3568+
<entry>Name of the type</entry>
3569+
</row>
3570+
3571+
<row>
3572+
<entry><literal>privilege_type</literal></entry>
3573+
<entry><type>character_data</type></entry>
3574+
<entry>Always <literal>TYPE USAGE</literal></entry>
3575+
</row>
3576+
3577+
<row>
3578+
<entry><literal>is_grantable</literal></entry>
3579+
<entry><type>yes_or_no</type></entry>
3580+
<entry><literal>YES</literal> if the privilege is grantable, <literal>NO</literal> if not</entry>
3581+
</row>
3582+
</tbody>
3583+
</tgroup>
3584+
</table>
3585+
</sect1>
3586+
35123587
<sect1 id="infoschema-role-usage-grants">
35133588
<title><literal>role_usage_grants</literal></title>
35143589

@@ -5499,6 +5574,80 @@ ORDER BY c.ordinal_position;
54995574
</note>
55005575
</sect1>
55015576

5577+
<sect1 id="infoschema-udt-privileges">
5578+
<title><literal>udt_privileges</literal></title>
5579+
5580+
<para>
5581+
The view <literal>udt_privileges</literal> is intended to identify
5582+
<literal>USAGE</literal> privileges granted on user-defined types
5583+
to a currently enabled role or by a currently enabled role. Since
5584+
data types do not have real privileges
5585+
in <productname>PostgreSQL</productname>, this view shows implicit
5586+
non-grantable <literal>USAGE</literal> privileges granted by the
5587+
owner to <literal>PUBLIC</literal> for all types, including
5588+
built-in ones (except domains,
5589+
see <xref linkend="infoschema-usage-privileges"> for that).
5590+
</para>
5591+
5592+
<table>
5593+
<title><literal>udt_privileges</literal> Columns</title>
5594+
5595+
<tgroup cols="3">
5596+
<thead>
5597+
<row>
5598+
<entry>Name</entry>
5599+
<entry>Data Type</entry>
5600+
<entry>Description</entry>
5601+
</row>
5602+
</thead>
5603+
5604+
<tbody>
5605+
<row>
5606+
<entry><literal>grantor</literal></entry>
5607+
<entry><type>sql_identifier</type></entry>
5608+
<entry>Name of the role that granted the privilege</entry>
5609+
</row>
5610+
5611+
<row>
5612+
<entry><literal>grantee</literal></entry>
5613+
<entry><type>sql_identifier</type></entry>
5614+
<entry>Name of the role that the privilege was granted to</entry>
5615+
</row>
5616+
5617+
<row>
5618+
<entry><literal>udt_catalog</literal></entry>
5619+
<entry><type>sql_identifier</type></entry>
5620+
<entry>Name of the database containing the type (always the current database)</entry>
5621+
</row>
5622+
5623+
<row>
5624+
<entry><literal>udt_schema</literal></entry>
5625+
<entry><type>sql_identifier</type></entry>
5626+
<entry>Name of the schema containing the type</entry>
5627+
</row>
5628+
5629+
<row>
5630+
<entry><literal>udt_name</literal></entry>
5631+
<entry><type>sql_identifier</type></entry>
5632+
<entry>Name of the type</entry>
5633+
</row>
5634+
5635+
<row>
5636+
<entry><literal>privilege_type</literal></entry>
5637+
<entry><type>character_data</type></entry>
5638+
<entry>Always <literal>TYPE USAGE</literal></entry>
5639+
</row>
5640+
5641+
<row>
5642+
<entry><literal>is_grantable</literal></entry>
5643+
<entry><type>yes_or_no</type></entry>
5644+
<entry><literal>YES</literal> if the privilege is grantable, <literal>NO</literal> if not</entry>
5645+
</row>
5646+
</tbody>
5647+
</tgroup>
5648+
</table>
5649+
</sect1>
5650+
55025651
<sect1 id="infoschema-usage-privileges">
55035652
<title><literal>usage_privileges</literal></title>
55045653

@@ -5585,6 +5734,224 @@ ORDER BY c.ordinal_position;
55855734
</table>
55865735
</sect1>
55875736

5737+
<sect1 id="infoschema-user-defined-types">
5738+
<title><literal>user_defined_types</literal></title>
5739+
5740+
<para>
5741+
The view <literal>user_defined_types</literal> currently contains
5742+
all composite types defined in the current database.
5743+
</para>
5744+
5745+
<para>
5746+
SQL knows about two kinds of user-defined types: structured types
5747+
(also known as composite types
5748+
in <productname>PostgreSQL</productname>) and distinct types (not
5749+
implemented in <productname>PostgreSQL</productname>). To be
5750+
future-proof, use the
5751+
column <literal>user_defined_type_category</literal> to
5752+
differentiate between these. Other user-defined types such as base
5753+
types and enums, which are <productname>PostgreSQL</productname>
5754+
extensions, are not shown here. For domains,
5755+
see <xref linkend="infoschema-domains"> instead.
5756+
</para>
5757+
5758+
<table>
5759+
<title><literal>user_defined_types</literal> Columns</title>
5760+
5761+
<tgroup cols="3">
5762+
<thead>
5763+
<row>
5764+
<entry>Name</entry>
5765+
<entry>Data Type</entry>
5766+
<entry>Description</entry>
5767+
</row>
5768+
</thead>
5769+
5770+
<tbody>
5771+
<row>
5772+
<entry><literal>user_defined_type_catalog</literal></entry>
5773+
<entry><type>sql_identifier</type></entry>
5774+
<entry>Name of the database that contains the type (always the current database)</entry>
5775+
</row>
5776+
5777+
<row>
5778+
<entry><literal>user_defined_type_schema</literal></entry>
5779+
<entry><type>sql_identifier</type></entry>
5780+
<entry>Name of the schema that contains the type</entry>
5781+
</row>
5782+
5783+
<row>
5784+
<entry><literal>user_defined_type_name</literal></entry>
5785+
<entry><type>sql_identifier</type></entry>
5786+
<entry>Name of the type</entry>
5787+
</row>
5788+
5789+
<row>
5790+
<entry><literal>user_defined_type_category</literal></entry>
5791+
<entry><type>character_data</type></entry>
5792+
<entry>
5793+
Currently always <literal>STRUCTURED</literal>
5794+
</entry>
5795+
</row>
5796+
5797+
<row>
5798+
<entry><literal>is_instantiable</literal></entry>
5799+
<entry><type>yes_or_no</type></entry>
5800+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5801+
</row>
5802+
5803+
<row>
5804+
<entry><literal>is_final</literal></entry>
5805+
<entry><type>yes_or_no</type></entry>
5806+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5807+
</row>
5808+
5809+
<row>
5810+
<entry><literal>ordering_form</literal></entry>
5811+
<entry><type>character_data</type></entry>
5812+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5813+
</row>
5814+
5815+
<row>
5816+
<entry><literal>ordering_category</literal></entry>
5817+
<entry><type>character_data</type></entry>
5818+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5819+
</row>
5820+
5821+
<row>
5822+
<entry><literal>ordering_routine_catalog</literal></entry>
5823+
<entry><type>sql_identifier</type></entry>
5824+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5825+
</row>
5826+
5827+
<row>
5828+
<entry><literal>ordering_routine_schema</literal></entry>
5829+
<entry><type>sql_identifier</type></entry>
5830+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5831+
</row>
5832+
5833+
<row>
5834+
<entry><literal>ordering_routine_name</literal></entry>
5835+
<entry><type>sql_identifier</type></entry>
5836+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5837+
</row>
5838+
5839+
<row>
5840+
<entry><literal>reference_type</literal></entry>
5841+
<entry><type>character_data</type></entry>
5842+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5843+
</row>
5844+
5845+
<row>
5846+
<entry><literal>data_type</literal></entry>
5847+
<entry><type>character_data</type></entry>
5848+
<entry>
5849+
Always <literal>USER-DEFINED TYPE</literal> (for joining
5850+
against <literal>object_type</literal> columns in other
5851+
views)
5852+
</entry>
5853+
</row>
5854+
5855+
<row>
5856+
<entry><literal>character_maximum_length</literal></entry>
5857+
<entry><type>cardinal_number</type></entry>
5858+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5859+
</row>
5860+
5861+
<row>
5862+
<entry><literal>character_octet_length</literal></entry>
5863+
<entry><type>cardinal_number</type></entry>
5864+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5865+
</row>
5866+
5867+
<row>
5868+
<entry><literal>character_set_catalog</literal></entry>
5869+
<entry><type>sql_identifier</type></entry>
5870+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5871+
</row>
5872+
5873+
<row>
5874+
<entry><literal>character_set_schema</literal></entry>
5875+
<entry><type>sql_identifier</type></entry>
5876+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5877+
</row>
5878+
5879+
<row>
5880+
<entry><literal>character_set_name</literal></entry>
5881+
<entry><type>sql_identifier</type></entry>
5882+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5883+
</row>
5884+
5885+
<row>
5886+
<entry><literal>collation_catalog</literal></entry>
5887+
<entry><type>sql_identifier</type></entry>
5888+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5889+
</row>
5890+
5891+
<row>
5892+
<entry><literal>collation_schema</literal></entry>
5893+
<entry><type>sql_identifier</type></entry>
5894+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5895+
</row>
5896+
5897+
<row>
5898+
<entry><literal>collation_name</literal></entry>
5899+
<entry><type>sql_identifier</type></entry>
5900+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5901+
</row>
5902+
5903+
<row>
5904+
<entry><literal>numeric_precision</literal></entry>
5905+
<entry><type>cardinal_number</type></entry>
5906+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5907+
</row>
5908+
5909+
<row>
5910+
<entry><literal>numeric_precision_radix</literal></entry>
5911+
<entry><type>cardinal_number</type></entry>
5912+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5913+
</row>
5914+
5915+
<row>
5916+
<entry><literal>numeric_scale</literal></entry>
5917+
<entry><type>cardinal_number</type></entry>
5918+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5919+
</row>
5920+
5921+
<row>
5922+
<entry><literal>datetime_precision</literal></entry>
5923+
<entry><type>cardinal_number</type></entry>
5924+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5925+
</row>
5926+
5927+
<row>
5928+
<entry><literal>interval_type</literal></entry>
5929+
<entry><type>character_data</type></entry>
5930+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5931+
</row>
5932+
5933+
<row>
5934+
<entry><literal>interval_precision</literal></entry>
5935+
<entry><type>character_data</type></entry>
5936+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5937+
</row>
5938+
5939+
<row>
5940+
<entry><literal>source_dtd_identifier</literal></entry>
5941+
<entry><type>sql_identifier</type></entry>
5942+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5943+
</row>
5944+
5945+
<row>
5946+
<entry><literal>ref_dtd_identifier</literal></entry>
5947+
<entry><type>sql_identifier</type></entry>
5948+
<entry>Applies to a feature not available in <productname>PostgreSQL</></entry>
5949+
</row>
5950+
</tbody>
5951+
</tgroup>
5952+
</table>
5953+
</sect1>
5954+
55885955
<sect1 id="infoschema-user-mapping-options">
55895956
<title><literal>user_mapping_options</literal></title>
55905957

0 commit comments

Comments
 (0)
0