1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>usage_privileges</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="The Information Schema"
16
HREF="information-schema.html"><LINK
19
HREF="infoschema-triggers.html"><LINK
21
TITLE="user_mapping_options"
22
HREF="infoschema-user-mapping-options.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="infoschema-triggers.html"
66
TITLE="The Information Schema"
67
HREF="information-schema.html"
74
>Chapter 34. The Information Schema</TD
80
TITLE="The Information Schema"
81
HREF="information-schema.html"
89
TITLE="user_mapping_options"
90
HREF="infoschema-user-mapping-options.html"
104
NAME="INFOSCHEMA-USAGE-PRIVILEGES"
107
>usage_privileges</TT
113
>usage_privileges</TT
118
> privileges granted on various kinds of
119
objects to a currently enabled role or by a currently enabled role.
123
>, this currently applies to
124
collations, domains, foreign-data wrappers, and foreign servers. There is one
125
row for each combination of object, grantor, and grantee.
128
> Since collations and domains do not have real privileges
132
>, this view shows implicit
136
> privileges granted by the
140
> for all collations and domains. The other
141
object types, however, show real privileges.
152
>usage_privileges</TT
158
><COL><COL><COL><THEAD
181
>Name of the role that granted the privilege</TD
195
>Name of the role that the privilege was granted to</TD
209
>Name of the database containing the object (always the current database)</TD
223
>Name of the schema containing the object, if applicable,
224
else an empty string</TD
238
>Name of the object</TD
260
>FOREIGN DATA WRAPPER</TT
298
> if the privilege is grantable, <TT
312
SUMMARY="Footer navigation table"
323
HREF="infoschema-triggers.html"
341
HREF="infoschema-user-mapping-options.html"
360
HREF="information-schema.html"
370
>user_mapping_options</TT
b'\\ No newline at end of file'