I386LINUX/util/I386LINUX/doc/postgresql/html/app-dropuser.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >dropuser</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="PostgreSQL Client Applications"
  16 HREF="reference-client.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="droplang"
  19 HREF="app-droplang.html"><LINK
  20 REL="NEXT"
  21 TITLE="ecpg"
  22 HREF="app-ecpg.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="REFENTRY"
  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="app-droplang.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="app-droplang.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="app-ecpg.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="app-ecpg.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><H1
  91 ><A
  92 NAME="APP-DROPUSER"
  93 ></A
  94 ><SPAN
  95 CLASS="APPLICATION"
  96 >dropuser</SPAN
  97 ></H1
  98 ><DIV
  99 CLASS="REFNAMEDIV"
 100 ><A
 101 NAME="AEN44060"
 102 ></A
 103 ><H2
 104 >Name</H2
 105 >dropuser&nbsp;--&nbsp;remove a <SPAN
 106 CLASS="PRODUCTNAME"
 107 >PostgreSQL</SPAN
 108 > user account</DIV
 109 ><A
 110 NAME="AEN44064"
 111 ></A
 112 ><DIV
 113 CLASS="REFSYNOPSISDIV"
 114 ><A
 115 NAME="AEN44066"
 116 ></A
 117 ><H2
 118 >Synopsis</H2
 119 ><P
 120 ><TT
 121 CLASS="COMMAND"
 122 >dropuser</TT
 123 > [<VAR
 124 CLASS="REPLACEABLE"
 125 >option</VAR
 126 >...] [<VAR
 127 CLASS="REPLACEABLE"
 128 >username</VAR
 129 >]</P
 130 ></DIV
 131 ><DIV
 132 CLASS="REFSECT1"
 133 ><A
 134 NAME="AEN44073"
 135 ></A
 136 ><H2
 137 >Description</H2
 138 ><P
 139 >   <SPAN
 140 CLASS="APPLICATION"
 141 >dropuser</SPAN
 142 > removes an existing
 143    <SPAN
 144 CLASS="PRODUCTNAME"
 145 >PostgreSQL</SPAN
 146 > user
 147    <SPAN
 148 CLASS="emphasis"
 149 ><I
 150 CLASS="EMPHASIS"
 151 >and</I
 152 ></SPAN
 153 > the databases which that user owned.
 154    Only superusers (users with <TT
 155 CLASS="LITERAL"
 156 >usesuper</TT
 157 > set in
 158    the <TT
 159 CLASS="LITERAL"
 160 >pg_shadow</TT
 161 > table) can destroy
 162    <SPAN
 163 CLASS="PRODUCTNAME"
 164 >PostgreSQL</SPAN
 165 > users.
 166   </P
 167 ><P
 168 >   <SPAN
 169 CLASS="APPLICATION"
 170 >dropuser</SPAN
 171 > is a wrapper around the
 172    <ACRONYM
 173 CLASS="ACRONYM"
 174 >SQL</ACRONYM
 175 > command <A
 176 HREF="sql-dropuser.html"
 177 ><I
 178 >DROP USER</I
 179 ></A
 180 >.
 181    There is no effective difference between dropping users via
 182    this utility and via other methods for accessing the server.
 183   </P
 184 ></DIV
 185 ><DIV
 186 CLASS="REFSECT1"
 187 ><A
 188 NAME="AEN44086"
 189 ></A
 190 ><H2
 191 >Options</H2
 192 ><P
 193 >   <SPAN
 194 CLASS="APPLICATION"
 195 >dropuser</SPAN
 196 > accepts the following command-line arguments:
 197
 198     <P
 199 ></P
 200 ></P><DIV
 201 CLASS="VARIABLELIST"
 202 ><DL
 203 ><DT
 204 ><VAR
 205 CLASS="REPLACEABLE"
 206 >username</VAR
 207 ></DT
 208 ><DD
 209 ><P
 210 >       Specifies the name of the <SPAN
 211 CLASS="PRODUCTNAME"
 212 >PostgreSQL</SPAN
 213 > user to be removed.
 214         You will be prompted for a name if none is specified on the command line.
 215        </P
 216 ></DD
 217 ><DT
 218 ><VAR
 219 CLASS="OPTION"
 220 >-e</VAR
 221 ><BR><VAR
 222 CLASS="OPTION"
 223 >--echo</VAR
 224 ></DT
 225 ><DD
 226 ><P
 227 >        Echo the commands that <SPAN
 228 CLASS="APPLICATION"
 229 >dropuser</SPAN
 230 > generates
 231         and sends to the server.
 232        </P
 233 ></DD
 234 ><DT
 235 ><VAR
 236 CLASS="OPTION"
 237 >-i</VAR
 238 ><BR><VAR
 239 CLASS="OPTION"
 240 >--interactive</VAR
 241 ></DT
 242 ><DD
 243 ><P
 244 >        Prompt for confirmation before actually removing the user.
 245        </P
 246 ></DD
 247 ><DT
 248 ><VAR
 249 CLASS="OPTION"
 250 >-q</VAR
 251 ><BR><VAR
 252 CLASS="OPTION"
 253 >--quiet</VAR
 254 ></DT
 255 ><DD
 256 ><P
 257 >        Do not display a response.
 258        </P
 259 ></DD
 260 ></DL
 261 ></DIV
 262 ><P>
 263   </P
 264 ><P
 265 >   <SPAN
 266 CLASS="APPLICATION"
 267 >dropuser</SPAN
 268 > also accepts the following
 269    command-line arguments for connection parameters:
 270
 271    <P
 272 ></P
 273 ></P><DIV
 274 CLASS="VARIABLELIST"
 275 ><DL
 276 ><DT
 277 ><VAR
 278 CLASS="OPTION"
 279 >-h <VAR
 280 CLASS="REPLACEABLE"
 281 >host</VAR
 282 ></VAR
 283 ><BR><VAR
 284 CLASS="OPTION"
 285 >--host <VAR
 286 CLASS="REPLACEABLE"
 287 >host</VAR
 288 ></VAR
 289 ></DT
 290 ><DD
 291 ><P
 292 >       Specifies the host name of the machine on which the
 293         server
 294         is running.  If the value begins with a slash, it is used
 295         as the directory for the Unix domain socket.
 296        </P
 297 ></DD
 298 ><DT
 299 ><VAR
 300 CLASS="OPTION"
 301 >-p <VAR
 302 CLASS="REPLACEABLE"
 303 >port</VAR
 304 ></VAR
 305 ><BR><VAR
 306 CLASS="OPTION"
 307 >--port <VAR
 308 CLASS="REPLACEABLE"
 309 >port</VAR
 310 ></VAR
 311 ></DT
 312 ><DD
 313 ><P
 314 >       Specifies the TCP port or local Unix domain socket file
 315         extension on which the server
 316         is listening for connections.
 317        </P
 318 ></DD
 319 ><DT
 320 ><VAR
 321 CLASS="OPTION"
 322 >-U <VAR
 323 CLASS="REPLACEABLE"
 324 >username</VAR
 325 ></VAR
 326 ><BR><VAR
 327 CLASS="OPTION"
 328 >--username <VAR
 329 CLASS="REPLACEABLE"
 330 >username</VAR
 331 ></VAR
 332 ></DT
 333 ><DD
 334 ><P
 335 >        User name to connect as (not the user name to drop)
 336        </P
 337 ></DD
 338 ><DT
 339 ><VAR
 340 CLASS="OPTION"
 341 >-W</VAR
 342 ><BR><VAR
 343 CLASS="OPTION"
 344 >--password</VAR
 345 ></DT
 346 ><DD
 347 ><P
 348 >        Force password prompt (to connect to the server, not for the
 349         password of the user to be dropped).
 350        </P
 351 ></DD
 352 ></DL
 353 ></DIV
 354 ><P>
 355   </P
 356 ></DIV
 357 ><DIV
 358 CLASS="REFSECT1"
 359 ><A
 360 NAME="AEN44156"
 361 ></A
 362 ><H2
 363 >Environment</H2
 364 ><P
 365 ></P
 366 ><DIV
 367 CLASS="VARIABLELIST"
 368 ><DL
 369 ><DT
 370 ><TT
 371 CLASS="ENVAR"
 372 >PGHOST</TT
 373 ><BR><TT
 374 CLASS="ENVAR"
 375 >PGPORT</TT
 376 ><BR><TT
 377 CLASS="ENVAR"
 378 >PGUSER</TT
 379 ></DT
 380 ><DD
 381 ><P
 382 >      Default connection parameters
 383      </P
 384 ></DD
 385 ></DL
 386 ></DIV
 387 ></DIV
 388 ><DIV
 389 CLASS="REFSECT1"
 390 ><A
 391 NAME="AEN44168"
 392 ></A
 393 ><H2
 394 >Diagnostics</H2
 395 ><P
 396 >   In case of difficulty, see <A
 397 HREF="sql-dropuser.html"
 398 ><I
 399 >DROP USER</I
 400 ></A
 401 > and <A
 402 HREF="app-psql.html"
 403 ><SPAN
 404 CLASS="APPLICATION"
 405 >psql</SPAN
 406 ></A
 407 > for
 408    discussions of potential problems and error messages.
 409    The database server must be running at the
 410    targeted host.  Also, any default connection settings and environment
 411    variables used by the <SPAN
 412 CLASS="APPLICATION"
 413 >libpq</SPAN
 414 > front-end
 415    library will apply.
 416   </P
 417 ></DIV
 418 ><DIV
 419 CLASS="REFSECT1"
 420 ><A
 421 NAME="AEN44174"
 422 ></A
 423 ><H2
 424 >Examples</H2
 425 ><P
 426 >    To remove user <TT
 427 CLASS="LITERAL"
 428 >joe</TT
 429 > from the default database
 430     server:
 431 </P><PRE
 432 CLASS="SCREEN"
 433 ><SAMP
 434 CLASS="PROMPT"
 435 >$ </SAMP
 436 ><KBD
 437 CLASS="USERINPUT"
 438 >dropuser joe</KBD
 439 >
 440 <SAMP
 441 CLASS="COMPUTEROUTPUT"
 442 >DROP USER</SAMP
 443 ></PRE
 444 ><P>
 445    </P
 446 ><P
 447 >    To remove user <TT
 448 CLASS="LITERAL"
 449 >joe</TT
 450 > using the server on host
 451     <TT
 452 CLASS="LITERAL"
 453 >eden</TT
 454 >, port 5000, with verification and a peek at the underlying
 455     command:
 456 </P><PRE
 457 CLASS="SCREEN"
 458 ><SAMP
 459 CLASS="PROMPT"
 460 >$ </SAMP
 461 ><KBD
 462 CLASS="USERINPUT"
 463 >dropuser -p 5000 -h eden -i -e joe</KBD
 464 >
 465 <SAMP
 466 CLASS="COMPUTEROUTPUT"
 467 >User "joe" and any owned databases will be permanently deleted.
 468 Are you sure? (y/n) </SAMP
 469 ><KBD
 470 CLASS="USERINPUT"
 471 >y</KBD
 472 >
 473 <SAMP
 474 CLASS="COMPUTEROUTPUT"
 475 >DROP USER "joe"
 476 DROP USER</SAMP
 477 ></PRE
 478 ><P>
 479    </P
 480 ></DIV
 481 ><DIV
 482 CLASS="REFSECT1"
 483 ><A
 484 NAME="AEN44191"
 485 ></A
 486 ><H2
 487 >See Also</H2
 488 ><A
 489 HREF="app-createuser.html"
 490 ><SPAN
 491 CLASS="APPLICATION"
 492 >createuser</SPAN
 493 ></A
 494 >, <A
 495 HREF="sql-dropuser.html"
 496 ><I
 497 >DROP USER</I
 498 ></A
 499 ></DIV
 500 ><DIV
 501 CLASS="NAVFOOTER"
 502 ><HR
 503 ALIGN="LEFT"
 504 WIDTH="100%"><TABLE
 505 SUMMARY="Footer navigation table"
 506 WIDTH="100%"
 507 BORDER="0"
 508 CELLPADDING="0"
 509 CELLSPACING="0"
 510 ><TR
 511 ><TD
 512 WIDTH="33%"
 513 ALIGN="left"
 514 VALIGN="top"
 515 ><A
 516 HREF="app-droplang.html"
 517 ACCESSKEY="P"
 518 >Prev</A
 519 ></TD
 520 ><TD
 521 WIDTH="34%"
 522 ALIGN="center"
 523 VALIGN="top"
 524 ><A
 525 HREF="index.html"
 526 ACCESSKEY="H"
 527 >Home</A
 528 ></TD
 529 ><TD
 530 WIDTH="33%"
 531 ALIGN="right"
 532 VALIGN="top"
 533 ><A
 534 HREF="app-ecpg.html"
 535 ACCESSKEY="N"
 536 >Next</A
 537 ></TD
 538 ></TR
 539 ><TR
 540 ><TD
 541 WIDTH="33%"
 542 ALIGN="left"
 543 VALIGN="top"
 544 ><SPAN
 545 CLASS="APPLICATION"
 546 >droplang</SPAN
 547 ></TD
 548 ><TD
 549 WIDTH="34%"
 550 ALIGN="center"
 551 VALIGN="top"
 552 ><A
 553 HREF="reference-client.html"
 554 ACCESSKEY="U"
 555 >Up</A
 556 ></TD
 557 ><TD
 558 WIDTH="33%"
 559 ALIGN="right"
 560 VALIGN="top"
 561 ><SPAN
 562 CLASS="APPLICATION"
 563 >ecpg</SPAN
 564 ></TD
 565 ></TR
 566 ></TABLE
 567 ></DIV
 568 ></BODY
 569 ></HTML
 570 >