CREATE ROLE
CREATE ROLErole_name
{NOT IDENTIFIED | IDENTIFIED BYpassword
| IDENTIFIED EXTERNALLY | IDENTIFIED GLOBALLY }
Creates a role (role_name), which is a set of privileges that can be granted to users.
Specifies that a user granted the role does not need to be verified when enabling it.
Specifies that a password must be provided when enabling the role.
Specifies that the operating system verifies the user enabling the role.
Specifies that the Oracle Security Service verifies the user enabling the role.