From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- .../sgml/html/infoschema-routine-privileges.html | 62 ++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-routine-privileges.html (limited to 'doc/src/sgml/html/infoschema-routine-privileges.html') diff --git a/doc/src/sgml/html/infoschema-routine-privileges.html b/doc/src/sgml/html/infoschema-routine-privileges.html new file mode 100644 index 0000000..06d1d86 --- /dev/null +++ b/doc/src/sgml/html/infoschema-routine-privileges.html @@ -0,0 +1,62 @@ + +37.41. routine_privileges
37.41. routine_privileges
Prev UpChapter 37. The Information SchemaHome Next

37.41. routine_privileges #

+ The view routine_privileges identifies all + privileges granted on functions to a currently enabled role or by a + currently enabled role. There is one row for each combination of function, + grantor, and grantee. +

Table 37.39. routine_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 +

+ specific_catalog sql_identifier +

+

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

+ specific_schema sql_identifier +

+

+ Name of the schema containing the function +

+ specific_name sql_identifier +

+

+ The “specific name” of the function. See Section 37.45 for more information. +

+ routine_catalog sql_identifier +

+

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

+ routine_schema sql_identifier +

+

+ Name of the schema containing the function +

+ routine_name sql_identifier +

+

+ Name of the function (might be duplicated in case of overloading) +

+ privilege_type character_data +

+

+ Always EXECUTE (the only privilege type for functions) +

+ is_grantable yes_or_no +

+

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


Prev Up Next
37.40. routine_column_usage Home 37.42. routine_routine_usage
\ No newline at end of file -- cgit v1.2.3