|
【赛迪网－it技术报道】生成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>
至此,执行成功。 |
