create_group

Langue: en

Version: 2007-04-20 (openSuse - 09/10/07)

Section: 7 (Divers)

NAME

CREATE GROUP - define a new database role

SYNOPSIS


CREATE GROUP name [ [ WITH ] option [ ... ] ]



where option can be:

    

      SUPERUSER | NOSUPERUSER

    | CREATEDB | NOCREATEDB

    | CREATEROLE | NOCREATEROLE

    | CREATEUSER | NOCREATEUSER

    | INHERIT | NOINHERIT

    | LOGIN | NOLOGIN

    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'

    | VALID UNTIL 'timestamp' 

    | IN ROLE rolename [, ...]

    | IN GROUP rolename [, ...]

    | ROLE rolename [, ...]

    | ADMIN rolename [, ...]

    | USER rolename [, ...]

    | SYSID uid 



DESCRIPTION

CREATE GROUP is now an alias for CREATE ROLE [create_role(7)], which see for more information.

COMPATIBILITY

There is no CREATE GROUP statement in the SQL standard.

SEE ALSO

CREATE ROLE [create_role(7)]