请问建好的数据库安全性中，没有了dba 角色，如何生成？？急，谢！！！！！

Question

你查询dba_roles
看到底有没有，我不相信

Answer 1

dba不用生成，库存角色存，只有自已删除的可能.

Answer 2

我查了一下dba_roles表，发现确实没有"DBA"角色：已连接。ROLE                           PASSWORD
------------------------------ --------
CONNECT                        NO
SELECT_CATALOG_ROLE            NO
EXECUTE_CATALOG_ROLE           NO
DELETE_CATALOG_ROLE            NO
EXP_FULL_DATABASE              NO
IMP_FULL_DATABASE              NO
RECOVERY_CATALOG_OWNER         NO
AQ_ADMINISTRATOR_ROLE          NO
AQ_USER_ROLE                   NO
SNMPAGENT                      NO
OEM_MONITOR                    NO
HS_ADMIN_ROLE                  NO
JAVA_DEPLOY                    NO
JAVAUSERPRIV                   NO
JAVAIDPRIV                     NO
JAVASYSPRIV                    NO
JAVADEBUGPRIV                  NO
JAVA_ADMIN                     NO
CTXAPP                         NO
TIMESERIES_DEVELOPER           NO
TIMESERIES_DBA                 NO已选择21行。

Answer 3

select * from user_role_privs;看什结果?

Answer 4

以下三个用户的对比，分别system、zdwy、timecardSQL> select user from dual;USER
------------------------------
SYSTEMSQL> select * from dba_roles;ROLE                           PASSWORD_REQUIRED
------------------------------ -----------------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
.........................SQL> select user from dual;USER
------------------------------
ZDWYSQL> select granted_role from user_role_privs;GRANTED_ROLE
------------------------------
CONNECT
DBA
RESOURCESQL> select * from dba_roles;ROLE                           PASSWORD_REQUIRED
------------------------------ -----------------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
.............SQL> select user from dual;USER
------------------------------
TIMECARDSQL> select granted_role from user_role_privs;GRANTED_ROLE
------------------------------
CONNECT
RESOURCESQL> select * from dba_roles;select * from dba_rolesORA-00942: 表或视图不存在

Answer 5

SQL> select user from dual;USER
------------------------------
SYSTEMSQL> select * from dba_roles;ROLE                           PASSWORD_REQUIRED
------------------------------ -----------------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
.........................
这里不是有dba角色吗？上面怎么没有，你的查询是怎么查的？

Answer 6

到Security Manager中去修改！