December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE ROLE
CREATE ROLE rolename
{NOT IDENTIFIED | IDENTIFIED
{EXTERNALLY | GLOBALLY |
BY PASSWORD |
USING [schema.]package}}Creates a role. When you create a role, it is automatically granted to you as a default role.
Specifies that no password is required for the role.
Indicates the way the user will be authenticated before being allowed to enable the role or assume the role as a default role. Options are:
Local user must provide password to enable role.
A package will verify the user. Used for application roles. If a schema name is not provided, the package is assumed to be in your schema. New with Oracle9i.
External user is authorized by a third-party service, like the operating system.
User is authorized by an enterprise directory service.