<PRE
CLASS="PROGRAMLISTING"
>CREATE ROLE jonathan LOGIN;</PRE
><P>
  </P
><P
>   Create a role with a password:
</P><PRE
CLASS="PROGRAMLISTING"
>CREATE USER davide WITH PASSWORD 'jw8s0F4';</PRE
><P>
   (<TT
CLASS="COMMAND"
>CREATE USER</TT
> is the same as <TT
CLASS="COMMAND"
>CREATE ROLE</TT
> except
   that it implies <TT
CLASS="LITERAL"
>LOGIN</TT
>.)
  </P
><P
>   Create a role with a password that is valid until the end of 2004.
   After one second has ticked in 2005, the password is no longer
   valid