← Back to branch summary

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

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-role-table-grants.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:
doc/src/sgml/html/infoschema-role-table-grants.html
 
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
>role_table_grants</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="role_routine_grants"
 
19
HREF="infoschema-role-routine-grants.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="role_usage_grants"
 
22
HREF="infoschema-role-usage-grants.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="role_routine_grants"
 
57
HREF="infoschema-role-routine-grants.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="role_usage_grants"
 
90
HREF="infoschema-role-usage-grants.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-ROLE-TABLE-GRANTS"
 
105
>34.35. <TT
 
106
CLASS="LITERAL"
 
107
>role_table_grants</TT
 
108
></A
 
109
></H1
 
110
><P
 
111
>   The view <TT
 
112
CLASS="LITERAL"
 
113
>role_table_grants</TT
 
114
> identifies all
 
115
   privileges granted on tables or views where the grantor or grantee
 
116
   is a currently enabled role.  Further information can be found
 
117
   under <TT
 
118
CLASS="LITERAL"
 
119
>table_privileges</TT
 
120
>.  The only effective
 
121
   difference between this view
 
122
   and <TT
 
123
CLASS="LITERAL"
 
124
>table_privileges</TT
 
125
> is that this view omits
 
126
   tables that have been made accessible to the current user by way of
 
127
   a grant to public.
 
128
  </P
 
129
><DIV
 
130
CLASS="TABLE"
 
131
><A
 
132
NAME="AEN47164"
 
133
></A
 
134
><P
 
135
><B
 
136
>Table 34-33. <TT
 
137
CLASS="LITERAL"
 
138
>role_table_grants</TT
 
139
> Columns</B
 
140
></P
 
141
><TABLE
 
142
BORDER="1"
 
143
CLASS="CALSTABLE"
 
144
><COL><COL><COL><THEAD
 
145
><TR
 
146
><TH
 
147
>Name</TH
 
148
><TH
 
149
>Data Type</TH
 
150
><TH
 
151
>Description</TH
 
152
></TR
 
153
></THEAD
 
154
><TBODY
 
155
><TR
 
156
><TD
 
157
><TT
 
158
CLASS="LITERAL"
 
159
>grantor</TT
 
160
></TD
 
161
><TD
 
162
><TT
 
163
CLASS="TYPE"
 
164
>sql_identifier</TT
 
165
></TD
 
166
><TD
 
167
>Name of the role that granted the privilege</TD
 
168
></TR
 
169
><TR
 
170
><TD
 
171
><TT
 
172
CLASS="LITERAL"
 
173
>grantee</TT
 
174
></TD
 
175
><TD
 
176
><TT
 
177
CLASS="TYPE"
 
178
>sql_identifier</TT
 
179
></TD
 
180
><TD
 
181
>Name of the role that the privilege was granted to</TD
 
182
></TR
 
183
><TR
 
184
><TD
 
185
><TT
 
186
CLASS="LITERAL"
 
187
>table_catalog</TT
 
188
></TD
 
189
><TD
 
190
><TT
 
191
CLASS="TYPE"
 
192
>sql_identifier</TT
 
193
></TD
 
194
><TD
 
195
>Name of the database that contains the table (always the current database)</TD
 
196
></TR
 
197
><TR
 
198
><TD
 
199
><TT
 
200
CLASS="LITERAL"
 
201
>table_schema</TT
 
202
></TD
 
203
><TD
 
204
><TT
 
205
CLASS="TYPE"
 
206
>sql_identifier</TT
 
207
></TD
 
208
><TD
 
209
>Name of the schema that contains the table</TD
 
210
></TR
 
211
><TR
 
212
><TD
 
213
><TT
 
214
CLASS="LITERAL"
 
215
>table_name</TT
 
216
></TD
 
217
><TD
 
218
><TT
 
219
CLASS="TYPE"
 
220
>sql_identifier</TT
 
221
></TD
 
222
><TD
 
223
>Name of the table</TD
 
224
></TR
 
225
><TR
 
226
><TD
 
227
><TT
 
228
CLASS="LITERAL"
 
229
>privilege_type</TT
 
230
></TD
 
231
><TD
 
232
><TT
 
233
CLASS="TYPE"
 
234
>character_data</TT
 
235
></TD
 
236
><TD
 
237
>       Type of the privilege: <TT
 
238
CLASS="LITERAL"
 
239
>SELECT</TT
 
240
>,
 
241
       <TT
 
242
CLASS="LITERAL"
 
243
>INSERT</TT
 
244
>, <TT
 
245
CLASS="LITERAL"
 
246
>UPDATE</TT
 
247
>,
 
248
       <TT
 
249
CLASS="LITERAL"
 
250
>DELETE</TT
 
251
>, <TT
 
252
CLASS="LITERAL"
 
253
>TRUNCATE</TT
 
254
>,
 
255
       <TT
 
256
CLASS="LITERAL"
 
257
>REFERENCES</TT
 
258
>, or <TT
 
259
CLASS="LITERAL"
 
260
>TRIGGER</TT
 
261
>
 
262
      </TD
 
263
></TR
 
264
><TR
 
265
><TD
 
266
><TT
 
267
CLASS="LITERAL"
 
268
>is_grantable</TT
 
269
></TD
 
270
><TD
 
271
><TT
 
272
CLASS="TYPE"
 
273
>yes_or_no</TT
 
274
></TD
 
275
><TD
 
276
><TT
 
277
CLASS="LITERAL"
 
278
>YES</TT
 
279
> if the privilege is grantable, <TT
 
280
CLASS="LITERAL"
 
281
>NO</TT
 
282
> if not</TD
 
283
></TR
 
284
><TR
 
285
><TD
 
286
><TT
 
287
CLASS="LITERAL"
 
288
>with_hierarchy</TT
 
289
></TD
 
290
><TD
 
291
><TT
 
292
CLASS="TYPE"
 
293
>yes_or_no</TT
 
294
></TD
 
295
><TD
 
296
>Applies to a feature not available in <SPAN
 
297
CLASS="PRODUCTNAME"
 
298
>PostgreSQL</SPAN
 
299
></TD
 
300
></TR
 
301
></TBODY
 
302
></TABLE
 
303
></DIV
 
304
></DIV
 
305
><DIV
 
306
CLASS="NAVFOOTER"
 
307
><HR
 
308
ALIGN="LEFT"
 
309
WIDTH="100%"><TABLE
 
310
SUMMARY="Footer navigation table"
 
311
WIDTH="100%"
 
312
BORDER="0"
 
313
CELLPADDING="0"
 
314
CELLSPACING="0"
 
315
><TR
 
316
><TD
 
317
WIDTH="33%"
 
318
ALIGN="left"
 
319
VALIGN="top"
 
320
><A
 
321
HREF="infoschema-role-routine-grants.html"
 
322
ACCESSKEY="P"
 
323
>Prev</A
 
324
></TD
 
325
><TD
 
326
WIDTH="34%"
 
327
ALIGN="center"
 
328
VALIGN="top"
 
329
><A
 
330
HREF="index.html"
 
331
ACCESSKEY="H"
 
332
>Home</A
 
333
></TD
 
334
><TD
 
335
WIDTH="33%"
 
336
ALIGN="right"
 
337
VALIGN="top"
 
338
><A
 
339
HREF="infoschema-role-usage-grants.html"
 
340
ACCESSKEY="N"
 
341
>Next</A
 
342
></TD
 
343
></TR
 
344
><TR
 
345
><TD
 
346
WIDTH="33%"
 
347
ALIGN="left"
 
348
VALIGN="top"
 
349
><TT
 
350
CLASS="LITERAL"
 
351
>role_routine_grants</TT
 
352
></TD
 
353
><TD
 
354
WIDTH="34%"
 
355
ALIGN="center"
 
356
VALIGN="top"
 
357
><A
 
358
HREF="information-schema.html"
 
359
ACCESSKEY="U"
 
360
>Up</A
 
361
></TD
 
362
><TD
 
363
WIDTH="33%"
 
364
ALIGN="right"
 
365
VALIGN="top"
 
366
><TT
 
367
CLASS="LITERAL"
 
368
>role_usage_grants</TT
 
369
></TD
 
370
></TR
 
371
></TABLE
 
372
></DIV
 
373
></BODY
 
374
></HTML
 
375
>
 
 
b'\\ No newline at end of file'