~ubuntu-branches/ubuntu/precise/postgresql-9.1/precise-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-user-mappings.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
ImportĀ upstreamĀ versionĀ 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>user_mappings</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="The Information Schema"
 
16
HREF="information-schema.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="user_mapping_options"
 
19
HREF="infoschema-user-mapping-options.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="view_column_usage"
 
22
HREF="infoschema-view-column-usage.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="user_mapping_options"
 
57
HREF="infoschema-user-mapping-options.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="The Information Schema"
 
67
HREF="information-schema.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 34. The Information Schema</TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="The Information Schema"
 
81
HREF="information-schema.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="view_column_usage"
 
90
HREF="infoschema-view-column-usage.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="SECT1"
 
101
><H1
 
102
CLASS="SECT1"
 
103
><A
 
104
NAME="INFOSCHEMA-USER-MAPPINGS"
 
105
>34.55. <TT
 
106
CLASS="LITERAL"
 
107
>user_mappings</TT
 
108
></A
 
109
></H1
 
110
><P
 
111
>   The view <TT
 
112
CLASS="LITERAL"
 
113
>user_mappings</TT
 
114
> contains all user
 
115
   mappings defined in the current database.  Only those user mappings
 
116
   are shown where the current user has access to the corresponding
 
117
   foreign server (by way of being the owner or having some
 
118
   privilege).
 
119
  </P
 
120
><DIV
 
121
CLASS="TABLE"
 
122
><A
 
123
NAME="AEN49090"
 
124
></A
 
125
><P
 
126
><B
 
127
>Table 34-53. <TT
 
128
CLASS="LITERAL"
 
129
>user_mappings</TT
 
130
> Columns</B
 
131
></P
 
132
><TABLE
 
133
BORDER="1"
 
134
CLASS="CALSTABLE"
 
135
><COL><COL><COL><THEAD
 
136
><TR
 
137
><TH
 
138
>Name</TH
 
139
><TH
 
140
>Data Type</TH
 
141
><TH
 
142
>Description</TH
 
143
></TR
 
144
></THEAD
 
145
><TBODY
 
146
><TR
 
147
><TD
 
148
><TT
 
149
CLASS="LITERAL"
 
150
>authorization_identifier</TT
 
151
></TD
 
152
><TD
 
153
><TT
 
154
CLASS="TYPE"
 
155
>sql_identifier</TT
 
156
></TD
 
157
><TD
 
158
>Name of the user being mapped,
 
159
      or <TT
 
160
CLASS="LITERAL"
 
161
>PUBLIC</TT
 
162
> if the mapping is public</TD
 
163
></TR
 
164
><TR
 
165
><TD
 
166
><TT
 
167
CLASS="LITERAL"
 
168
>foreign_server_catalog</TT
 
169
></TD
 
170
><TD
 
171
><TT
 
172
CLASS="TYPE"
 
173
>sql_identifier</TT
 
174
></TD
 
175
><TD
 
176
>Name of the database that the foreign server used by this
 
177
      mapping is defined in (always the current database)</TD
 
178
></TR
 
179
><TR
 
180
><TD
 
181
><TT
 
182
CLASS="LITERAL"
 
183
>foreign_server_name</TT
 
184
></TD
 
185
><TD
 
186
><TT
 
187
CLASS="TYPE"
 
188
>sql_identifier</TT
 
189
></TD
 
190
><TD
 
191
>Name of the foreign server used by this mapping</TD
 
192
></TR
 
193
></TBODY
 
194
></TABLE
 
195
></DIV
 
196
></DIV
 
197
><DIV
 
198
CLASS="NAVFOOTER"
 
199
><HR
 
200
ALIGN="LEFT"
 
201
WIDTH="100%"><TABLE
 
202
SUMMARY="Footer navigation table"
 
203
WIDTH="100%"
 
204
BORDER="0"
 
205
CELLPADDING="0"
 
206
CELLSPACING="0"
 
207
><TR
 
208
><TD
 
209
WIDTH="33%"
 
210
ALIGN="left"
 
211
VALIGN="top"
 
212
><A
 
213
HREF="infoschema-user-mapping-options.html"
 
214
ACCESSKEY="P"
 
215
>Prev</A
 
216
></TD
 
217
><TD
 
218
WIDTH="34%"
 
219
ALIGN="center"
 
220
VALIGN="top"
 
221
><A
 
222
HREF="index.html"
 
223
ACCESSKEY="H"
 
224
>Home</A
 
225
></TD
 
226
><TD
 
227
WIDTH="33%"
 
228
ALIGN="right"
 
229
VALIGN="top"
 
230
><A
 
231
HREF="infoschema-view-column-usage.html"
 
232
ACCESSKEY="N"
 
233
>Next</A
 
234
></TD
 
235
></TR
 
236
><TR
 
237
><TD
 
238
WIDTH="33%"
 
239
ALIGN="left"
 
240
VALIGN="top"
 
241
><TT
 
242
CLASS="LITERAL"
 
243
>user_mapping_options</TT
 
244
></TD
 
245
><TD
 
246
WIDTH="34%"
 
247
ALIGN="center"
 
248
VALIGN="top"
 
249
><A
 
250
HREF="information-schema.html"
 
251
ACCESSKEY="U"
 
252
>Up</A
 
253
></TD
 
254
><TD
 
255
WIDTH="33%"
 
256
ALIGN="right"
 
257
VALIGN="top"
 
258
><TT
 
259
CLASS="LITERAL"
 
260
>view_column_usage</TT
 
261
></TD
 
262
></TR
 
263
></TABLE
 
264
></DIV
 
265
></BODY
 
266
></HTML
 
267
>
 
 
b'\\ No newline at end of file'