oracle创建用户dba,Oracle DBA上机实例--创建用户角色赋权

三、检查验证

1.需打开IE，在地址栏中输入http://localhost:5560/isqlplus，进入isqlplus，以system 用户登录目标数据库，设置输出方式为单页输出。

set echo on

select name as name from v$database;

show parameter o7

select * from dba_users where username like '%0%';

select * from dba_ts_quotas where username like '%0%';

select * from dba_tablespaces;

select * from dba_sys_privs where grantee like '%0%' or grantee like 'R\_%' escape '\';

select * from dba_tab_privs where grantee like '%0%' or grantee like 'R\_%' escape '\';

select * from dba_roles where role like 'R\_%' escape '\';

select * from dba_role_privs where grantee like '%0%';