如何创建DBA ROLE

发表日期：2008-2-9

本人一次碰到有人将数据库DBA ROLE删除掉了，惊奇之余 ,只好想办法恢复，经查找资料，终于完全恢复了DBA ROLE，现将恢复过程与大家共享：

用 sys/xxxx as sysdba登录sqlplus，然后执行下列语句：

SQL> create role dba;

SQL> grant all privileges to dba with admin option;

SQL> grant select_catalog_role to dba with admin option;

SQL> grant execute_catalog_role to dba with admin option;

SQL> grant delete_catalog_role to dba with admin option;

EXPlanation:
============

The DBA role is created at database creation time by the "sql.bsq" script. (The "sql.bsq" script is typically found in the $Oracle_HOME/dbs or the
$ORACLE_HOME/rdbms/admin Directory.)

Additional grants are made to dba through other scripts in the admin directory.

For example, exp_full_database and imp_full_database in catexp.sql.

The above commands are excerpts from the "sql.bsq" script

上一篇：Oracle SQL性能优化系列讲座之三人气:891
下一篇：关于Logminer 人气:636

浏览全部Oracle教程的内容 Dreamweaver插件下载网页广告代码祝你圣诞节快乐 2009年新年快乐