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-role-usage-grants.html | 57 ++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-role-usage-grants.html (limited to 'doc/src/sgml/html/infoschema-role-usage-grants.html') diff --git a/doc/src/sgml/html/infoschema-role-usage-grants.html b/doc/src/sgml/html/infoschema-role-usage-grants.html new file mode 100644 index 0000000..4c12b77 --- /dev/null +++ b/doc/src/sgml/html/infoschema-role-usage-grants.html @@ -0,0 +1,57 @@ + +37.39. role_usage_grants
37.39. role_usage_grants
Prev UpChapter 37. The Information SchemaHome Next

37.39. role_usage_grants

+ The view role_usage_grants identifies + USAGE privileges granted on various kinds of + objects where the grantor or grantee is a currently enabled role. + Further information can be found under + usage_privileges. The only effective difference + between this view and usage_privileges is that + this view omits objects that have been made accessible to the + current user by way of a grant to PUBLIC. +

Table 37.37. role_usage_grants Columns

+ Column Type +

+

+ Description +

+ grantor sql_identifier +

+

+ The name of the role that granted the privilege +

+ grantee sql_identifier +

+

+ The 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.38. role_udt_grants Home 37.40. routine_column_usage
\ No newline at end of file -- cgit v1.2.3