1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>31.25.routine_privileges</title>
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
<link rel="up" href="information-schema.html" title="Chapter31.The Information Schema">
<link rel="prev" href="infoschema-role-usage-grants.html" title="31.24.role_usage_grants">
<link rel="next" href="infoschema-routines.html" title="31.26.routines">
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="sect1" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="infoschema-routine-privileges"></a>31.25.<code class="literal">routine_privileges</code></h2></div></div></div>
<p> The view <code class="literal">routine_privileges</code> identifies all
privileges granted on functions to the current user or by the
current user. There is one row for each combination of function,
grantor, and grantee. Privileges granted to groups are identified
in the view <code class="literal">role_routine_grants</code>.
</p>
<div class="table">
<a name="id698882"></a><p class="title"><b>Table31.23.<code class="literal">routine_privileges</code> Columns</b></p>
<div class="table-contents"><table summary="routine_privileges Columns" border="1">
<colgroup>
<col>
<col>
<col>
</colgroup>
<thead><tr>
<th>Name</th>
<th>Data Type</th>
<th>Description</th>
</tr></thead>
<tbody>
<tr>
<td><code class="literal">grantor</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the user that granted the privilege</td>
</tr>
<tr>
<td><code class="literal">grantee</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the user or group that the privilege was granted to</td>
</tr>
<tr>
<td><code class="literal">specific_catalog</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the database containing the function (always the current database)</td>
</tr>
<tr>
<td><code class="literal">specific_schema</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the schema containing the function</td>
</tr>
<tr>
<td><code class="literal">specific_name</code></td>
<td><code class="type">sql_identifier</code></td>
<td> The “<span class="quote">specific name</span>” of the function. See <a href="infoschema-routines.html" title="31.26.routines">Section31.26, “<code class="literal">routines</code>”</a> for more information.
</td>
</tr>
<tr>
<td><code class="literal">routine_catalog</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the database containing the function (always the current database)</td>
</tr>
<tr>
<td><code class="literal">routine_schema</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the schema containing the function</td>
</tr>
<tr>
<td><code class="literal">routine_name</code></td>
<td><code class="type">sql_identifier</code></td>
<td>Name of the function (may be duplicated in case of overloading)</td>
</tr>
<tr>
<td><code class="literal">privilege_type</code></td>
<td><code class="type">character_data</code></td>
<td>Always <code class="literal">EXECUTE</code> (the only privilege type for functions)</td>
</tr>
<tr>
<td><code class="literal">is_grantable</code></td>
<td><code class="type">character_data</code></td>
<td>
<code class="literal">YES</code> if the privilege is grantable, <code class="literal">NO</code> if not</td>
</tr>
</tbody>
</table></div>
</div>
<br class="table-break"><p> Note that the column <code class="literal">grantee</code> makes no
distinction between users and groups. If you have users and groups
with the same name, there is unfortunately no way to distinguish
them. A future version of <span class="productname">PostgreSQL</span>
will possibly prohibit having users and groups with the same name.
</p>
</div></body>
</html>
|
