Oracle:

CREATE ROLE

CREATE ROLE role
[ NOT IDENTIFIED
| IDENTIFIED { BY password
| USING [ schema. ] package
| EXTERNALLY
| GLOBALLY
}
] ;

Example

CREATE ROLE dw_manager;

CREATE ROLE dw_manager
IDENTIFIED BY warehouse;

CREATE ROLE warehouse_user IDENTIFIED GLOBALLY;

CREATE ROLE warehouse_user IDENTIFIED EXTERNALLY;

bottom of page