查询所有DBA账号select * from dba_role_privs where granted_role='DBA';或者select * from (select distinct connect_by_root grantee username,granted_role from dba_role_privs connect by prior granted_...
时光匆匆,记录是对思维的沉淀;
查询所有DBA账号select * from dba_role_privs where granted_role='DBA';或者select * from (select distinct connect_by_root grantee username,granted_role from dba_role_privs connect by prior granted_...
1 运行SQLPLUS工具 sqlplus 2 以OS的默认身份连接 / as sysdba 3 显示当前用户名 show user 4 直接进入SQLPLUS命令提示符 sqlplus /nolog 5 在命令提示符以OS身份连接 connect / as sysdba 6 以SYSTEM的身份连接 connect system/xxxxxxx@服务名 7 显示当然用户有哪些表...