From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- .../sgml/html/infoschema-data-type-privileges.html | 52 ++++++++++++++++++++++ 1 file changed, 52 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-data-type-privileges.html (limited to 'doc/src/sgml/html/infoschema-data-type-privileges.html') diff --git a/doc/src/sgml/html/infoschema-data-type-privileges.html b/doc/src/sgml/html/infoschema-data-type-privileges.html new file mode 100644 index 0000000..811ab2d --- /dev/null +++ b/doc/src/sgml/html/infoschema-data-type-privileges.html @@ -0,0 +1,52 @@ + +37.20. data_type_privileges
37.20. data_type_privileges
Prev UpChapter 37. The Information SchemaHome Next

37.20. data_type_privileges

+ The view data_type_privileges identifies all + data type descriptors that the current user has access to, by way + of being the owner of the described object or having some privilege + for it. A data type descriptor is generated whenever a data type + is used in the definition of a table column, a domain, or a + function (as parameter or return type) and stores some information + about how the data type is used in that instance (for example, the + declared maximum length, if applicable). Each data type + descriptor is assigned an arbitrary identifier that is unique + among the data type descriptor identifiers assigned for one object + (table, domain, function). This view is probably not useful for + applications, but it is used to define some other views in the + information schema. +

Table 37.18. data_type_privileges Columns

+ Column Type +

+

+ Description +

+ object_catalog sql_identifier +

+

+ Name of the database that contains the described object (always the current database) +

+ object_schema sql_identifier +

+

+ Name of the schema that contains the described object +

+ object_name sql_identifier +

+

+ Name of the described object +

+ object_type character_data +

+

+ The type of the described object: one of + TABLE (the data type descriptor pertains to + a column of that table), DOMAIN (the data + type descriptors pertains to that domain), + ROUTINE (the data type descriptor pertains + to a parameter or the return data type of that function). +

+ dtd_identifier sql_identifier +

+

+ The identifier of the data type descriptor, which is unique + among the data type descriptors for that same object. +


Prev Up Next
37.19. constraint_table_usage Home 37.21. domain_constraints
\ No newline at end of file -- cgit v1.2.3