I686LINUX/util/I686LINUX/doc/postgresql/html/infoschema-table-privileges.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >table_privileges</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 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="table_constraints"
  19 HREF="infoschema-table-constraints.html"><LINK
  20 REL="NEXT"
  21 TITLE="tables"
  22 HREF="infoschema-tables.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="infoschema-table-constraints.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="information-schema.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 32. The Information Schema</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="information-schema.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="infoschema-tables.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="INFOSCHEMA-TABLE-PRIVILEGES"
  96 >32.35. <TT
  97 CLASS="LITERAL"
  98 >table_privileges</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >table_privileges</TT
 105 > identifies all
 106    privileges granted on tables or views to the current user or by the
 107    current user.  There is one row for each combination of table,
 108    grantor, and grantee.  Privileges granted to groups are identified
 109    in the view <TT
 110 CLASS="LITERAL"
 111 >role_table_grants</TT
 112 >.
 113   </P
 114 ><DIV
 115 CLASS="TABLE"
 116 ><A
 117 NAME="AEN28086"
 118 ></A
 119 ><P
 120 ><B
 121 >Table 32-33. <TT
 122 CLASS="LITERAL"
 123 >table_privileges</TT
 124 > Columns</B
 125 ></P
 126 ><TABLE
 127 BORDER="1"
 128 CLASS="CALSTABLE"
 129 ><COL><COL><COL><THEAD
 130 ><TR
 131 ><TH
 132 >Name</TH
 133 ><TH
 134 >Data Type</TH
 135 ><TH
 136 >Description</TH
 137 ></TR
 138 ></THEAD
 139 ><TBODY
 140 ><TR
 141 ><TD
 142 ><TT
 143 CLASS="LITERAL"
 144 >grantor</TT
 145 ></TD
 146 ><TD
 147 ><TT
 148 CLASS="TYPE"
 149 >sql_identifier</TT
 150 ></TD
 151 ><TD
 152 >Name of the user that granted the privilege</TD
 153 ></TR
 154 ><TR
 155 ><TD
 156 ><TT
 157 CLASS="LITERAL"
 158 >grantee</TT
 159 ></TD
 160 ><TD
 161 ><TT
 162 CLASS="TYPE"
 163 >sql_identifier</TT
 164 ></TD
 165 ><TD
 166 >Name of the user or group that the privilege was granted to</TD
 167 ></TR
 168 ><TR
 169 ><TD
 170 ><TT
 171 CLASS="LITERAL"
 172 >table_catalog</TT
 173 ></TD
 174 ><TD
 175 ><TT
 176 CLASS="TYPE"
 177 >sql_identifier</TT
 178 ></TD
 179 ><TD
 180 >Name of the database that contains the table (always the current database)</TD
 181 ></TR
 182 ><TR
 183 ><TD
 184 ><TT
 185 CLASS="LITERAL"
 186 >table_schema</TT
 187 ></TD
 188 ><TD
 189 ><TT
 190 CLASS="TYPE"
 191 >sql_identifier</TT
 192 ></TD
 193 ><TD
 194 >Name of the schema that contains the table</TD
 195 ></TR
 196 ><TR
 197 ><TD
 198 ><TT
 199 CLASS="LITERAL"
 200 >table_name</TT
 201 ></TD
 202 ><TD
 203 ><TT
 204 CLASS="TYPE"
 205 >sql_identifier</TT
 206 ></TD
 207 ><TD
 208 >Name of the table</TD
 209 ></TR
 210 ><TR
 211 ><TD
 212 ><TT
 213 CLASS="LITERAL"
 214 >privilege_type</TT
 215 ></TD
 216 ><TD
 217 ><TT
 218 CLASS="TYPE"
 219 >character_data</TT
 220 ></TD
 221 ><TD
 222 >       Type of the privilege: <TT
 223 CLASS="LITERAL"
 224 >SELECT</TT
 225 >,
 226        <TT
 227 CLASS="LITERAL"
 228 >DELETE</TT
 229 >, <TT
 230 CLASS="LITERAL"
 231 >INSERT</TT
 232 >,
 233        <TT
 234 CLASS="LITERAL"
 235 >UPDATE</TT
 236 >, <TT
 237 CLASS="LITERAL"
 238 >REFERENCES</TT
 239 >,
 240        <TT
 241 CLASS="LITERAL"
 242 >RULE</TT
 243 >, or <TT
 244 CLASS="LITERAL"
 245 >TRIGGER</TT
 246 >
 247       </TD
 248 ></TR
 249 ><TR
 250 ><TD
 251 ><TT
 252 CLASS="LITERAL"
 253 >is_grantable</TT
 254 ></TD
 255 ><TD
 256 ><TT
 257 CLASS="TYPE"
 258 >character_data</TT
 259 ></TD
 260 ><TD
 261 ><TT
 262 CLASS="LITERAL"
 263 >YES</TT
 264 > if the privilege is grantable, <TT
 265 CLASS="LITERAL"
 266 >NO</TT
 267 > if not</TD
 268 ></TR
 269 ><TR
 270 ><TD
 271 ><TT
 272 CLASS="LITERAL"
 273 >with_hierarchy</TT
 274 ></TD
 275 ><TD
 276 ><TT
 277 CLASS="TYPE"
 278 >character_data</TT
 279 ></TD
 280 ><TD
 281 >Applies to a feature not available in PostgreSQL</TD
 282 ></TR
 283 ></TBODY
 284 ></TABLE
 285 ></DIV
 286 ><P
 287 >   Note that the column <TT
 288 CLASS="LITERAL"
 289 >grantee</TT
 290 > makes no
 291    distinction between users and groups.  If you have users and groups
 292    with the same name, there is unfortunately no way to distinguish
 293    them.  A future version of <SPAN
 294 CLASS="PRODUCTNAME"
 295 >PostgreSQL</SPAN
 296 >
 297    will possibly prohibit having users and groups with the same name.
 298   </P
 299 ></DIV
 300 ><DIV
 301 CLASS="NAVFOOTER"
 302 ><HR
 303 ALIGN="LEFT"
 304 WIDTH="100%"><TABLE
 305 SUMMARY="Footer navigation table"
 306 WIDTH="100%"
 307 BORDER="0"
 308 CELLPADDING="0"
 309 CELLSPACING="0"
 310 ><TR
 311 ><TD
 312 WIDTH="33%"
 313 ALIGN="left"
 314 VALIGN="top"
 315 ><A
 316 HREF="infoschema-table-constraints.html"
 317 ACCESSKEY="P"
 318 >Prev</A
 319 ></TD
 320 ><TD
 321 WIDTH="34%"
 322 ALIGN="center"
 323 VALIGN="top"
 324 ><A
 325 HREF="index.html"
 326 ACCESSKEY="H"
 327 >Home</A
 328 ></TD
 329 ><TD
 330 WIDTH="33%"
 331 ALIGN="right"
 332 VALIGN="top"
 333 ><A
 334 HREF="infoschema-tables.html"
 335 ACCESSKEY="N"
 336 >Next</A
 337 ></TD
 338 ></TR
 339 ><TR
 340 ><TD
 341 WIDTH="33%"
 342 ALIGN="left"
 343 VALIGN="top"
 344 ><TT
 345 CLASS="LITERAL"
 346 >table_constraints</TT
 347 ></TD
 348 ><TD
 349 WIDTH="34%"
 350 ALIGN="center"
 351 VALIGN="top"
 352 ><A
 353 HREF="information-schema.html"
 354 ACCESSKEY="U"
 355 >Up</A
 356 ></TD
 357 ><TD
 358 WIDTH="33%"
 359 ALIGN="right"
 360 VALIGN="top"
 361 ><TT
 362 CLASS="LITERAL"
 363 >tables</TT
 364 ></TD
 365 ></TR
 366 ></TABLE
 367 ></DIV
 368 ></BODY
 369 ></HTML
 370 >