I686LINUX/util/I686LINUX/doc/postgresql/html/infoschema-role-column-grants.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >role_column_grants</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="referential_constraints"
  19 HREF="infoschema-referential-constraints.html"><LINK
  20 REL="NEXT"
  21 TITLE="role_routine_grants"
  22 HREF="infoschema-role-routine-grants.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-referential-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-role-routine-grants.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-ROLE-COLUMN-GRANTS"
  96 >32.21. <TT
  97 CLASS="LITERAL"
  98 >role_column_grants</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >role_column_grants</TT
 105 > identifies all
 106    privileges granted on columns to a group that the current user is a
 107    member of.  Further information can be found under
 108    <TT
 109 CLASS="LITERAL"
 110 >column_privileges</TT
 111 >.
 112   </P
 113 ><DIV
 114 CLASS="TABLE"
 115 ><A
 116 NAME="AEN26905"
 117 ></A
 118 ><P
 119 ><B
 120 >Table 32-19. <TT
 121 CLASS="LITERAL"
 122 >role_column_grants</TT
 123 > Columns</B
 124 ></P
 125 ><TABLE
 126 BORDER="1"
 127 CLASS="CALSTABLE"
 128 ><COL><COL><COL><THEAD
 129 ><TR
 130 ><TH
 131 >Name</TH
 132 ><TH
 133 >Data Type</TH
 134 ><TH
 135 >Description</TH
 136 ></TR
 137 ></THEAD
 138 ><TBODY
 139 ><TR
 140 ><TD
 141 ><TT
 142 CLASS="LITERAL"
 143 >grantor</TT
 144 ></TD
 145 ><TD
 146 ><TT
 147 CLASS="TYPE"
 148 >sql_identifier</TT
 149 ></TD
 150 ><TD
 151 >Name of the user that granted the privilege</TD
 152 ></TR
 153 ><TR
 154 ><TD
 155 ><TT
 156 CLASS="LITERAL"
 157 >grantee</TT
 158 ></TD
 159 ><TD
 160 ><TT
 161 CLASS="TYPE"
 162 >sql_identifier</TT
 163 ></TD
 164 ><TD
 165 >Name of the group that the privilege was granted to</TD
 166 ></TR
 167 ><TR
 168 ><TD
 169 ><TT
 170 CLASS="LITERAL"
 171 >table_catalog</TT
 172 ></TD
 173 ><TD
 174 ><TT
 175 CLASS="TYPE"
 176 >sql_identifier</TT
 177 ></TD
 178 ><TD
 179 >Name of the database that contains the table that contains the column (always the current database)</TD
 180 ></TR
 181 ><TR
 182 ><TD
 183 ><TT
 184 CLASS="LITERAL"
 185 >table_schema</TT
 186 ></TD
 187 ><TD
 188 ><TT
 189 CLASS="TYPE"
 190 >sql_identifier</TT
 191 ></TD
 192 ><TD
 193 >Name of the schema that contains the table that contains the column</TD
 194 ></TR
 195 ><TR
 196 ><TD
 197 ><TT
 198 CLASS="LITERAL"
 199 >table_name</TT
 200 ></TD
 201 ><TD
 202 ><TT
 203 CLASS="TYPE"
 204 >sql_identifier</TT
 205 ></TD
 206 ><TD
 207 >Name of the table that contains the column</TD
 208 ></TR
 209 ><TR
 210 ><TD
 211 ><TT
 212 CLASS="LITERAL"
 213 >column_name</TT
 214 ></TD
 215 ><TD
 216 ><TT
 217 CLASS="TYPE"
 218 >sql_identifier</TT
 219 ></TD
 220 ><TD
 221 >Name of the column</TD
 222 ></TR
 223 ><TR
 224 ><TD
 225 ><TT
 226 CLASS="LITERAL"
 227 >privilege_type</TT
 228 ></TD
 229 ><TD
 230 ><TT
 231 CLASS="TYPE"
 232 >character_data</TT
 233 ></TD
 234 ><TD
 235 >       Type of the privilege: <TT
 236 CLASS="LITERAL"
 237 >SELECT</TT
 238 >,
 239        <TT
 240 CLASS="LITERAL"
 241 >INSERT</TT
 242 >, <TT
 243 CLASS="LITERAL"
 244 >UPDATE</TT
 245 >, or
 246        <TT
 247 CLASS="LITERAL"
 248 >REFERENCES</TT
 249 >
 250       </TD
 251 ></TR
 252 ><TR
 253 ><TD
 254 ><TT
 255 CLASS="LITERAL"
 256 >is_grantable</TT
 257 ></TD
 258 ><TD
 259 ><TT
 260 CLASS="TYPE"
 261 >character_data</TT
 262 ></TD
 263 ><TD
 264 ><TT
 265 CLASS="LITERAL"
 266 >YES</TT
 267 > if the privilege is grantable, <TT
 268 CLASS="LITERAL"
 269 >NO</TT
 270 > if not</TD
 271 ></TR
 272 ></TBODY
 273 ></TABLE
 274 ></DIV
 275 ></DIV
 276 ><DIV
 277 CLASS="NAVFOOTER"
 278 ><HR
 279 ALIGN="LEFT"
 280 WIDTH="100%"><TABLE
 281 SUMMARY="Footer navigation table"
 282 WIDTH="100%"
 283 BORDER="0"
 284 CELLPADDING="0"
 285 CELLSPACING="0"
 286 ><TR
 287 ><TD
 288 WIDTH="33%"
 289 ALIGN="left"
 290 VALIGN="top"
 291 ><A
 292 HREF="infoschema-referential-constraints.html"
 293 ACCESSKEY="P"
 294 >Prev</A
 295 ></TD
 296 ><TD
 297 WIDTH="34%"
 298 ALIGN="center"
 299 VALIGN="top"
 300 ><A
 301 HREF="index.html"
 302 ACCESSKEY="H"
 303 >Home</A
 304 ></TD
 305 ><TD
 306 WIDTH="33%"
 307 ALIGN="right"
 308 VALIGN="top"
 309 ><A
 310 HREF="infoschema-role-routine-grants.html"
 311 ACCESSKEY="N"
 312 >Next</A
 313 ></TD
 314 ></TR
 315 ><TR
 316 ><TD
 317 WIDTH="33%"
 318 ALIGN="left"
 319 VALIGN="top"
 320 ><TT
 321 CLASS="LITERAL"
 322 >referential_constraints</TT
 323 ></TD
 324 ><TD
 325 WIDTH="34%"
 326 ALIGN="center"
 327 VALIGN="top"
 328 ><A
 329 HREF="information-schema.html"
 330 ACCESSKEY="U"
 331 >Up</A
 332 ></TD
 333 ><TD
 334 WIDTH="33%"
 335 ALIGN="right"
 336 VALIGN="top"
 337 ><TT
 338 CLASS="LITERAL"
 339 >role_routine_grants</TT
 340 ></TD
 341 ></TR
 342 ></TABLE
 343 ></DIV
 344 ></BODY
 345 ></HTML
 346 >