From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/infoschema-usage-privileges.html | 66 ++++++++++++++++++++++ 1 file changed, 66 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-usage-privileges.html (limited to 'doc/src/sgml/html/infoschema-usage-privileges.html') diff --git a/doc/src/sgml/html/infoschema-usage-privileges.html b/doc/src/sgml/html/infoschema-usage-privileges.html new file mode 100644 index 0000000..65bdba0 --- /dev/null +++ b/doc/src/sgml/html/infoschema-usage-privileges.html @@ -0,0 +1,66 @@ + +37.59. usage_privileges
37.59. usage_privileges
Prev UpChapter 37. The Information SchemaHome Next

37.59. usage_privileges

+ The view usage_privileges identifies + USAGE privileges granted on various kinds of + objects to a currently enabled role or by a currently enabled role. + In PostgreSQL, this currently applies to + collations, domains, foreign-data wrappers, foreign servers, and sequences. There is one + row for each combination of object, grantor, and grantee. +

+ Since collations do not have real privileges + in PostgreSQL, this view shows implicit + non-grantable USAGE privileges granted by the + owner to PUBLIC for all collations. The other + object types, however, show real privileges. +

+ In PostgreSQL, sequences also support SELECT + and UPDATE privileges in addition to + the USAGE privilege. These are nonstandard and therefore + not visible in the information schema. +

Table 37.57. usage_privileges Columns

+ Column Type +

+

+ Description +

+ grantor sql_identifier +

+

+ Name of the role that granted the privilege +

+ grantee sql_identifier +

+

+ Name of the role that the privilege was granted to +

+ object_catalog sql_identifier +

+

+ Name of the database containing the object (always the current database) +

+ object_schema sql_identifier +

+

+ Name of the schema containing the object, if applicable, + else an empty string +

+ object_name sql_identifier +

+

+ Name of the object +

+ object_type character_data +

+

+ COLLATION or DOMAIN or FOREIGN DATA WRAPPER or FOREIGN SERVER or SEQUENCE +

+ privilege_type character_data +

+

+ Always USAGE +

+ is_grantable yes_or_no +

+

+ YES if the privilege is grantable, NO if not +


Prev Up Next
37.58. udt_privileges Home 37.60. user_defined_types
\ No newline at end of file -- cgit v1.2.3