『ORACLE』授予hr使用者檢視執行計劃權限（11g）

SQL>@?/sqlplus/admin/plustrce.sql

[email protected] hey~J->drop role plustrace;

Role dropped.

[email protected] hey~J->create role plustrace;

Role created.

[email protected] hey~J->

[email protected] hey~J->grant select on v_$sesstat to plustrace;

Grant succeeded.

[email protected] hey~J->grant select on v_$statname to plustrace;

Grant succeeded.

[email protected] hey~J->grant select on v_$mystat to plustrace;

Grant succeeded.

[email protected] hey~J->grant plustrace to dba with admin option;

Grant succeeded.

[email protected] hey~J->grant plustrace to hr;

Grant succeeded.

SQL>conn hr/hr

[email protected]>set autotrace traceonly;

[email protected]>select count(*) from t3 where id=1;

Execution Plan

----------------------------------------------------------

Plan hash value: 463314188

---------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

---------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | 1 | 13 | 7 (0)| 00:00:01 |

| 1 | SORT AGGREGATE | | 1 | 13 | | |

|* 2 | TABLE ACCESS FULL| T3 | 1 | 13 | 7 (0)| 00:00:01 |

---------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - filter("ID"=1)

Note

-----

- dynamic sampling used for this statement (level=2)

- SQL plan baseline "SQL_PLAN_ghfucv736fsc114fae16c" used for this statement

Statistics

----------------------------------------------------------

53 recursive calls

0 db block gets

82 consistent gets

0 physical reads

0 redo size

526 bytes sent via SQL*Net to client

524 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

5 sorts (memory)

0 sorts (disk)

1 rows processed