I386LINUX/util/I386LINUX/doc/postgresql/html/user-attributes.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >User Attributes</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="Database Users and Privileges"
  16 HREF="user-manag.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Database Users and Privileges"
  19 HREF="user-manag.html"><LINK
  20 REL="NEXT"
  21 TITLE="Groups"
  22 HREF="groups.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="user-manag.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="user-manag.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 17. Database Users and Privileges</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="user-manag.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="groups.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="USER-ATTRIBUTES"
  96 >17.2. User Attributes</A
  97 ></H1
  98 ><P
  99 >    A database user may have a number of attributes that define its
 100     privileges and interact with the client authentication system.
 101
 102     <P
 103 ></P
 104 ></P><DIV
 105 CLASS="VARIABLELIST"
 106 ><DL
 107 ><DT
 108 >superuser<A
 109 NAME="AEN17247"
 110 ></A
 111 ></DT
 112 ><DD
 113 ><P
 114 >        A database superuser bypasses all permission checks. Also,
 115         only a superuser can create new users. To create a database
 116         superuser, use <TT
 117 CLASS="LITERAL"
 118 >CREATE USER <VAR
 119 CLASS="REPLACEABLE"
 120 >name</VAR
 121 >
 122         CREATEUSER</TT
 123 >.
 124        </P
 125 ></DD
 126 ><DT
 127 >database creation<A
 128 NAME="AEN17255"
 129 ></A
 130 ></DT
 131 ><DD
 132 ><P
 133 >        A user must be explicitly given permission to create databases
 134         (except for superusers, since those bypass all permission
 135         checks). To create such a user, use <TT
 136 CLASS="LITERAL"
 137 >CREATE USER
 138         <VAR
 139 CLASS="REPLACEABLE"
 140 >name</VAR
 141 > CREATEDB</TT
 142 >.
 143        </P
 144 ></DD
 145 ><DT
 146 >password<A
 147 NAME="AEN17264"
 148 ></A
 149 ></DT
 150 ><DD
 151 ><P
 152 >        A password is only significant if the client authentication
 153         method requires the user to supply a password when connecting
 154         to the database. The <VAR
 155 CLASS="OPTION"
 156 >password</VAR
 157 >,
 158         <VAR
 159 CLASS="OPTION"
 160 >md5</VAR
 161 >, and <VAR
 162 CLASS="OPTION"
 163 >crypt</VAR
 164 > authentication methods
 165         make use of passwords. Database passwords are separate from
 166         operating system passwords. Specify a password upon user
 167         creation with <TT
 168 CLASS="LITERAL"
 169 >CREATE USER
 170         <VAR
 171 CLASS="REPLACEABLE"
 172 >name</VAR
 173 > PASSWORD '<VAR
 174 CLASS="REPLACEABLE"
 175 >string</VAR
 176 >'</TT
 177 >.
 178        </P
 179 ></DD
 180 ></DL
 181 ></DIV
 182 ><P>
 183
 184     A user's attributes can be modified after creation with
 185     <TT
 186 CLASS="COMMAND"
 187 >ALTER USER</TT
 188 >.<A
 189 NAME="AEN17275"
 190 ></A
 191 >
 192     See the reference pages for <TT
 193 CLASS="COMMAND"
 194 >CREATE USER</TT
 195 > and
 196     <TT
 197 CLASS="COMMAND"
 198 >ALTER USER</TT
 199 > for details.
 200    </P
 201 ><P
 202 >   A user can also set personal defaults for many of the run-time
 203    configuration settings described in <A
 204 HREF="runtime-config.html"
 205 >Section 16.4</A
 206 >.  For example, if for some reason you
 207    want to disable index scans (hint: not a good idea) anytime you
 208    connect, you can use
 209 </P><PRE
 210 CLASS="PROGRAMLISTING"
 211 >ALTER USER myname SET enable_indexscan TO off;</PRE
 212 ><P>
 213    This will save the setting (but not set it immediately) and in
 214    subsequent connections it will appear as though <TT
 215 CLASS="LITERAL"
 216 >SET enable_indexscan
 217    TO off;</TT
 218 > had been called right before the session started.
 219    You can still alter this setting during the session; it will only
 220    be the default. To undo any such setting, use <TT
 221 CLASS="LITERAL"
 222 >ALTER USER
 223    <VAR
 224 CLASS="REPLACEABLE"
 225 >username</VAR
 226 > RESET <VAR
 227 CLASS="REPLACEABLE"
 228 >varname</VAR
 229 >;</TT
 230 >.
 231   </P
 232 ></DIV
 233 ><DIV
 234 CLASS="NAVFOOTER"
 235 ><HR
 236 ALIGN="LEFT"
 237 WIDTH="100%"><TABLE
 238 SUMMARY="Footer navigation table"
 239 WIDTH="100%"
 240 BORDER="0"
 241 CELLPADDING="0"
 242 CELLSPACING="0"
 243 ><TR
 244 ><TD
 245 WIDTH="33%"
 246 ALIGN="left"
 247 VALIGN="top"
 248 ><A
 249 HREF="user-manag.html"
 250 ACCESSKEY="P"
 251 >Prev</A
 252 ></TD
 253 ><TD
 254 WIDTH="34%"
 255 ALIGN="center"
 256 VALIGN="top"
 257 ><A
 258 HREF="index.html"
 259 ACCESSKEY="H"
 260 >Home</A
 261 ></TD
 262 ><TD
 263 WIDTH="33%"
 264 ALIGN="right"
 265 VALIGN="top"
 266 ><A
 267 HREF="groups.html"
 268 ACCESSKEY="N"
 269 >Next</A
 270 ></TD
 271 ></TR
 272 ><TR
 273 ><TD
 274 WIDTH="33%"
 275 ALIGN="left"
 276 VALIGN="top"
 277 >Database Users and Privileges</TD
 278 ><TD
 279 WIDTH="34%"
 280 ALIGN="center"
 281 VALIGN="top"
 282 ><A
 283 HREF="user-manag.html"
 284 ACCESSKEY="U"
 285 >Up</A
 286 ></TD
 287 ><TD
 288 WIDTH="33%"
 289 ALIGN="right"
 290 VALIGN="top"
 291 >Groups</TD
 292 ></TR
 293 ></TABLE
 294 ></DIV
 295 ></BODY
 296 ></HTML
 297 >