.

</P><PRE
CLASS="PROGRAMLISTING"
>CREATE ROLE miriam WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01';</PRE
><P>
  </P
><P
>   Create a role that can create databases and manage roles:
</P><PRE
CLASS="PROGRAMLISTING"
>CREATE ROLE admin WITH CREATEDB CREATEROLE;</PRE
><P></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71867"
></A
><H2
>Compatibility</H2
><P
>   The <TT
CLASS="COMMAND"
>CREATE ROLE</TT
> statement is in the SQL standard,
   but the standard only requires the syntax
</P><PRE
CLASS="SYNO