Friday, April 25, 2008

List of Select Privileges to access different functions

List of select privileges required on the fixed views to execute different functions

**DISPLAY_CURSOR

V$SQL_PLAN, V$SESSION and V$SQL_PLAN_STATISTICS_ALL.

**DISPLAY_AWR

DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT, and V$DATABASE.

No comments: