Thursday, September 18, 2008

SESSION_ROLES

SESSION_ROLES describes the roles that are currently enabled to the user.

Column

Datatype

NULL

Description

ROLE

VARCHAR2(30)

NOT NULL

Name of the role

Note:

1.

select * from SESSION_ROLES;

ROLE

CONNECT

DBA

DELETE_CATALOG_ROLE

EXECUTE_CATALOG_ROLE

EXP_FULL_DATABASE

GATHER_SYSTEM_STATISTICS

HS_ADMIN_ROLE

IMP_FULL_DATABASE

JAVA_ADMIN

JAVA_DEPLOY

PLUSTRACE

SCHEDULER_ADMIN

SELECT_CATALOG_ROLE

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment