ITPub博客

首页 > 数据库 > 数据库开发技术 > public拥有AUTOTRACE

public拥有AUTOTRACE

原创 数据库开发技术 作者:OmarChina 时间:2007-08-28 13:04:22 0 删除 编辑
安装数据库后。这样搞下还是很不错的[@more@]

SQL> conn / as sysdba
Connected.
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan

Table created.

SQL> create public synonym plan_table for plan_table;
create public synonym plan_table for plan_table
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> grant all on plan_table to publicl
2 /
grant all on plan_table to publicl
*
ERROR at line 1:
ORA-01917: user or role 'PUBLICL' does not exist


SQL> grant all on plan_table to public;

Grant succeeded.

SQL> @$ORACLE_HOME/sqlplus/admin/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.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9925929/viewspace-966465/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    68
  • 访问量
    997209