1.查询当前连接登录用户

set lineshow off
SELECT USER();

2.查询当前数据库非系统用户信息

DM7查询SQL：

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 1000
select  du.user_id,
        du.username,
        du.default_tablespace,
	du.temporary_tablespace,
        du.created,
     -- du.profile,
        du.account_status status,
	su.rn_flag
from    dba_users du,
        sysusers su 
where du.user_id = su.id 
and   du.username not in ('SYSSSO','SYSDBA','SYSAUDITOR','SYS')
order by du.created;

DM8查询SQL

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 1000

select  du.user_id,
        du.username,
        du.default_tablespace,
	du.default_index_tablespace,
	du.temporary_tablespace,
        du.created,
     -- du.profile,
        du.account_status status,
	su.rn_flag
from    dba_users du,
        sysusers su 
where du.user_id = su.id 
and   du.username not in ('SYSSSO','SYSDBA','SYSAUDITOR','SYS')
order by du.created;

3.查询系统角色和角色权限

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 1000


--1.查询角色权限
select * 
from DBA_ROLE_PRIVS
where upper(grantee)=upper('&v_username')
;

--2.查询角色权限
select * 
from DBA_SYS_PRIVS
where upper(grantee)=upper('&v_username')
;