【转】autotrace权限赋予

一、配置autotrace

　　1、cd [ORACLE_HOME]/rdbms/admin;

　　2、以system用户登陆;

　　3、执行@utlxplan;

　　4、执行create public synonym plan_table for plan_table;

　　5、执行 grant all on plan_table to public;

　　二、创建plustrace角色

　　1、cd [ORACLE_HOME]/sqlplus/admin;

　　2、以sys或sysdba登陆;

　　3、运行@plustrce;

　　4、执行grant plustrace to public;

　　备注：也可以将public指定为某个用户。

　　[oracle@olivenan oracle]$ cd $ORACLE_HOME/rdbms/admin/

　　[oracle@olivenan admin]$ sqlplus system/oracle

　　SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 27 11:00:20 2007

　　Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

　　Connected to:

　　Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　SQL> @utlxplan

　　Table created.

　　SQL> create public synonym plan_table for plan_table;

　　Synonym created.

　　SQL> grant all on plan_table to public;

　　Grant succeeded.

　　SQL> exit

　　Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　[oracle@olivenan admin]$ cd $ORACLE_HOME/sqlplus/admin

　　[oracle@olivenan admin]$ sysplus "/as sysdba"

　　-bash: sysplus: command not found

　　[oracle@olivenan admin]$ sqlplus "/as sysdba"

　　SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 27 11:04:55 2007

　　Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

　　Connected to:

　　Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer Release 9.2.0.4.0 - Production

　　SQL> @plustrce

　　SQL>

　　SQL> drop role plustrace;

　　drop role plustrace

　　*

　　ERROR at line 1:

　　ORA-01919: role 'PLUSTRACE' does not exist

　　SQL> create role plustrace;

　　Role created.

　　SQL>

　　SQL> grant select on v_$sesstat to plustrace;

　　Grant succeeded.

　　SQL> grant select on v_$statname to plustrace;

　　Grant succeeded.

　　SQL> grant select on v_$mystat to plustrace;

　　Grant succeeded.

　　SQL> grant plustrace to dba with admin option;

　　Grant succeeded.

　　SQL>

　　SQL> set echo off

　　SQL> grant plustrace to public;

　　Grant succeeded.

　　SQL>

　　至此执行成功

来源：http://www.poluoluo.com/jzxy/201004/81923.html

转载于:https://www.cnblogs.com/Peyton-for-2012/archive/2013/06/13/3133828.html