Name

CREATE ROLE

Synopsis

CREATE ROLE role_name 
   {NOT IDENTIFIED |
    IDENTIFIED BY password |
    IDENTIFIED EXTERNALLY |
    IDENTIFIED GLOBALLY
   }

Creates a role (role_name), which is a set of privileges that can be granted to users.

Keywords

NOT IDENTIFIED

Specifies that a user granted the role does not need to be verified when enabling it.

IDENTIFIED BY

Specifies that a password must be provided when enabling the role.

IDENTIFIED EXTERNALLY

Specifies that the operating system verifies the user enabling the role.

IDENTIFIED GLOBALLY

Specifies that the Oracle Security Service verifies the user enabling the role.

Notes

You must have the CREATE ROLE privilege to issue this command. When you create a role, you are automatically granted that role WITH ADMIN OPTION, which allows you to grant or revoke the role, or to modify it using the ALTER ROLE command.

Example

The following example creates a role called “manager” and assigns the password “dilbert” to the role:

ALTER ROLE manager IDENTIFIED BY dilbert
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset