===========
CREATE ROLE
===========

Synopsis
--------

.. code-block:: none

    CREATE ROLE role_name
    [ WITH ADMIN ( user | USER user | ROLE role | CURRENT_USER | CURRENT_ROLE ) ]
    [ IN catalog ]

Description
-----------

``CREATE ROLE`` creates the specified role in ``catalog`` or in the
current catalog if ``catalog`` is not specified.

The optional ``WITH ADMIN`` clause causes the role to be created with
the specified user as a role admin. A role admin has permission to drop
or grant a role. If the optional ``WITH ADMIN`` clause is not
specified, the role is created with current user as admin.

Examples
--------

Create role ``admin`` ::

    CREATE ROLE admin;

Create role ``moderator`` with admin ``bob``::

    CREATE ROLE moderator WITH ADMIN USER bob;

Create role ``foo`` in catalog ``bar``::

    CREATE ROLE foo IN bar;

Limitations
-----------

Some connectors do not support role management.
See connector documentation for more details.

See Also
--------

:doc:`drop-role`, :doc:`set-role`, :doc:`grant-roles`, :doc:`revoke-roles`