ALTER ROLE

Name

ALTER ROLE

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

Changes the authorization level required to enable a role (role_name).

NOT IDENTIFIED: Specifies that a user granted the role does not need to be verified when enabling it.
IDENTIFIED BY: Specifies that the 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 Server verifies the user enabling the role.

You must have been granted the role via the WITH ADMIN OPTION or have the ALTER ANY ROLE privilege to issue this command.

The following example assigns the password “dilbert” to the manager 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.