1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
12 TITLE="PostgreSQL 7.4.1 Documentation"
13 HREF="index.html"><LINK
15 TITLE="PostgreSQL Client Applications"
16 HREF="reference-client.html"><LINK
19 HREF="app-createlang.html"><LINK
22 HREF="app-dropdb.html"><LINK
25 HREF="stylesheet.css"><META
27 CONTENT="2003-12-22T03:48:47"></HEAD
33 SUMMARY="Header navigation table"
43 >PostgreSQL 7.4.1 Documentation</TH
51 HREF="app-createlang.html"
60 HREF="app-createlang.html"
73 HREF="app-dropdb.html"
81 HREF="app-dropdb.html"
105 >createuser -- define a new <SPAN
113 CLASS="REFSYNOPSISDIV"
147 Only superusers (users with <TT
163 invoked by someone who can connect as a <SPAN
170 > Being a superuser also implies the ability to bypass access permission
171 checks within the database, so superuserdom should not be granted lightly.
177 > is a wrapper around the
182 HREF="sql-createuser.html"
187 There is no effective difference between creating users via
188 this utility and via other methods for accessing the server.
202 > accepts the following command-line arguments:
216 > Specifies the name of the <SPAN
219 > user to be created.
220 This name must be unique among all <SPAN
236 > The new user is allowed to create other users.
237 (Note: Actually, this makes the new user a <SPAN
244 The option is poorly named.)
257 > The new user is not allowed to create other users (i.e.,
258 the new user is a regular user, not a superuser).
272 > The new user is allowed to create databases.
285 > The new user is not allowed to create databases.
299 > Echo the commands that <SPAN
303 and sends to the server.
316 > Encrypts the user's password stored in the database. If not
317 specified, the default password behavior is used.
336 > Allows you to pick a non-default user ID for the new user. This is not
337 necessary, but some people like it.
350 > Does not encrypt the user's password stored in the database. If
351 not specified, the default password behavior is used.
367 > will issue a prompt for
368 the password of the new user. This is not necessary if you do not plan
369 on using password authentication.
382 > Do not display a response.
390 > You will be prompted for a name and other missing information if it
391 is not specified on the command line.
397 > also accepts the following
398 command-line arguments for connection parameters:
421 > Specifies the host name of the machine on which the
423 is running. If the value begins with a slash, it is used
424 as the directory for the Unix domain socket.
443 > Specifies the TCP port or local Unix domain socket file
444 extension on which the server
445 is listening for connections.
464 > User name to connect as (not the user name to create).
477 > Force password prompt (to connect to the server, not for the
478 password of the new user).
511 > Default connection parameters
525 > In case of difficulty, see <A
526 HREF="sql-createuser.html"
537 discussions of potential problems and error messages.
538 The database server must be running at the
539 targeted host. Also, any default connection settings and environment
540 variables used by the <SPAN
555 > To create a user <TT
558 > on the default database
570 CLASS="COMPUTEROUTPUT"
571 >Is the new user allowed to create databases? (y/n) </SAMP
577 CLASS="COMPUTEROUTPUT"
578 >Shall the new user be allowed to create more new users? (y/n) </SAMP
584 CLASS="COMPUTEROUTPUT"
590 > To create the same user <TT
597 >, port 5000, avoiding the prompts and
598 taking a look at the underlying command:
606 >createuser -p 5000 -h eden -D -A -e joe</KBD
609 CLASS="COMPUTEROUTPUT"
610 >CREATE USER "joe" NOCREATEDB NOCREATEUSER</SAMP
613 CLASS="COMPUTEROUTPUT"
627 HREF="app-dropuser.html"
633 HREF="sql-createuser.html"
643 SUMMARY="Footer navigation table"
654 HREF="app-createlang.html"
672 HREF="app-dropdb.html"
691 HREF="reference-client.html"