From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. 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..10441a6 --- /dev/null +++ b/doc/src/sgml/html/infoschema-routine-privileges.html @@ -0,0 +1,62 @@ + +36.40. routine_privileges
36.40. routine_privileges
Prev UpChapter 36. The Information SchemaHome Next

36.40. 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 36.38. 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 36.41 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
36.39. role_usage_grants Home 36.41. routines
\ No newline at end of file -- cgit v1.2.3