I386LINUX/util/I386LINUX/doc/postgresql/html/infoschema-routine-privileges.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >routine_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="role_usage_grants"
  19 HREF="infoschema-role-usage-grants.html"><LINK
  20 REL="NEXT"
  21 TITLE="routines"
  22 HREF="infoschema-routines.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-role-usage-grants.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-routines.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-ROUTINE-PRIVILEGES"
  96 >32.25. <TT
  97 CLASS="LITERAL"
  98 >routine_privileges</TT
  99 ></A
 100 ></H1
 101 ><P
 102 >   The view <TT
 103 CLASS="LITERAL"
 104 >routine_privileges</TT
 105 > identifies all
 106    privileges granted on functions to the current user or by the
 107    current user.  There is one row for each combination of function,
 108    grantor, and grantee.  Privileges granted to groups are identified
 109    in the view <TT
 110 CLASS="LITERAL"
 111 >role_routine_grants</TT
 112 >.
 113   </P
 114 ><DIV
 115 CLASS="TABLE"
 116 ><A
 117 NAME="AEN27199"
 118 ></A
 119 ><P
 120 ><B
 121 >Table 32-23. <TT
 122 CLASS="LITERAL"
 123 >routine_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 >specific_catalog</TT
 173 ></TD
 174 ><TD
 175 ><TT
 176 CLASS="TYPE"
 177 >sql_identifier</TT
 178 ></TD
 179 ><TD
 180 >Name of the database containing the function (always the current database)</TD
 181 ></TR
 182 ><TR
 183 ><TD
 184 ><TT
 185 CLASS="LITERAL"
 186 >specific_schema</TT
 187 ></TD
 188 ><TD
 189 ><TT
 190 CLASS="TYPE"
 191 >sql_identifier</TT
 192 ></TD
 193 ><TD
 194 >Name of the schema containing the function</TD
 195 ></TR
 196 ><TR
 197 ><TD
 198 ><TT
 199 CLASS="LITERAL"
 200 >specific_name</TT
 201 ></TD
 202 ><TD
 203 ><TT
 204 CLASS="TYPE"
 205 >sql_identifier</TT
 206 ></TD
 207 ><TD
 208 >       The <SPAN
 209 CLASS="QUOTE"
 210 >"specific name"</SPAN
 211 > of the function.  See <A
 212 HREF="infoschema-routines.html"
 213 >Section 32.26</A
 214 > for more information.
 215       </TD
 216 ></TR
 217 ><TR
 218 ><TD
 219 ><TT
 220 CLASS="LITERAL"
 221 >routine_catalog</TT
 222 ></TD
 223 ><TD
 224 ><TT
 225 CLASS="TYPE"
 226 >sql_identifier</TT
 227 ></TD
 228 ><TD
 229 >Name of the database containing the function (always the current database)</TD
 230 ></TR
 231 ><TR
 232 ><TD
 233 ><TT
 234 CLASS="LITERAL"
 235 >routine_schema</TT
 236 ></TD
 237 ><TD
 238 ><TT
 239 CLASS="TYPE"
 240 >sql_identifier</TT
 241 ></TD
 242 ><TD
 243 >Name of the schema containing the function</TD
 244 ></TR
 245 ><TR
 246 ><TD
 247 ><TT
 248 CLASS="LITERAL"
 249 >routine_name</TT
 250 ></TD
 251 ><TD
 252 ><TT
 253 CLASS="TYPE"
 254 >sql_identifier</TT
 255 ></TD
 256 ><TD
 257 >Name of the function (may be duplicated in case of overloading)</TD
 258 ></TR
 259 ><TR
 260 ><TD
 261 ><TT
 262 CLASS="LITERAL"
 263 >privilege_type</TT
 264 ></TD
 265 ><TD
 266 ><TT
 267 CLASS="TYPE"
 268 >character_data</TT
 269 ></TD
 270 ><TD
 271 >Always <TT
 272 CLASS="LITERAL"
 273 >EXECUTE</TT
 274 > (the only privilege type for functions)</TD
 275 ></TR
 276 ><TR
 277 ><TD
 278 ><TT
 279 CLASS="LITERAL"
 280 >is_grantable</TT
 281 ></TD
 282 ><TD
 283 ><TT
 284 CLASS="TYPE"
 285 >character_data</TT
 286 ></TD
 287 ><TD
 288 ><TT
 289 CLASS="LITERAL"
 290 >YES</TT
 291 > if the privilege is grantable, <TT
 292 CLASS="LITERAL"
 293 >NO</TT
 294 > if not</TD
 295 ></TR
 296 ></TBODY
 297 ></TABLE
 298 ></DIV
 299 ><P
 300 >   Note that the column <TT
 301 CLASS="LITERAL"
 302 >grantee</TT
 303 > makes no
 304    distinction between users and groups.  If you have users and groups
 305    with the same name, there is unfortunately no way to distinguish
 306    them.  A future version of <SPAN
 307 CLASS="PRODUCTNAME"
 308 >PostgreSQL</SPAN
 309 >
 310    will possibly prohibit having users and groups with the same name.
 311   </P
 312 ></DIV
 313 ><DIV
 314 CLASS="NAVFOOTER"
 315 ><HR
 316 ALIGN="LEFT"
 317 WIDTH="100%"><TABLE
 318 SUMMARY="Footer navigation table"
 319 WIDTH="100%"
 320 BORDER="0"
 321 CELLPADDING="0"
 322 CELLSPACING="0"
 323 ><TR
 324 ><TD
 325 WIDTH="33%"
 326 ALIGN="left"
 327 VALIGN="top"
 328 ><A
 329 HREF="infoschema-role-usage-grants.html"
 330 ACCESSKEY="P"
 331 >Prev</A
 332 ></TD
 333 ><TD
 334 WIDTH="34%"
 335 ALIGN="center"
 336 VALIGN="top"
 337 ><A
 338 HREF="index.html"
 339 ACCESSKEY="H"
 340 >Home</A
 341 ></TD
 342 ><TD
 343 WIDTH="33%"
 344 ALIGN="right"
 345 VALIGN="top"
 346 ><A
 347 HREF="infoschema-routines.html"
 348 ACCESSKEY="N"
 349 >Next</A
 350 ></TD
 351 ></TR
 352 ><TR
 353 ><TD
 354 WIDTH="33%"
 355 ALIGN="left"
 356 VALIGN="top"
 357 ><TT
 358 CLASS="LITERAL"
 359 >role_usage_grants</TT
 360 ></TD
 361 ><TD
 362 WIDTH="34%"
 363 ALIGN="center"
 364 VALIGN="top"
 365 ><A
 366 HREF="information-schema.html"
 367 ACCESSKEY="U"
 368 >Up</A
 369 ></TD
 370 ><TD
 371 WIDTH="33%"
 372 ALIGN="right"
 373 VALIGN="top"
 374 ><TT
 375 CLASS="LITERAL"
 376 >routines</TT
 377 ></TD
 378 ></TR
 379 ></TABLE
 380 ></DIV
 381 ></BODY
 382 ></HTML
 383 >