DBA_ROLESは、データベース内のすべてのロールを示します。
DBA_ROLES
ROLE
VARCHAR2(30)
NOT NULL
PASSWORD_REQUIRED
VARCHAR2(8)
AUTHENTICATION_TYPE
VARCHAR2(11)
NONE - CREATE ROLE role1;
NONE
CREATE ROLE
role1
;
EXTERNAL - CREATE ROLE role2 IDENTIFIED EXTERNALLY;
EXTERNAL
role2
IDENTIFIED EXTERNALLY;
GLOBAL - CREATE ROLE role3 IDENTIFIED GLOBALLY;
GLOBAL
role3
IDENTIFIED GLOBALLY;
APPLICATION - CREATE ROLE role4 IDENTIFIED USING schema.package;
APPLICATION
role4
IDENTIFIED USING
schema
.
package
PASSWORD - CREATE ROLE role5 IDENTIFIED BY role5;
PASSWORD
role5
IDENTIFIED BY