注:
视图dba_sys_privs是用来查询用户系统权限的;
视图dba_role_privs是用来查询用户角色的
在sqlplus 环境中运行下列语句：
define 1=‘关注的用户’
set linesize 200
select grantee, privilege from dba_sys_privs where grantee='&&1';
select grantee, GRANTED_ROLE from dba_role_privs where grantee='&&1';
select username, DEFAULT_TABLESPACE , TEMPORARY_TABLESPACE from dba_users where username='&&1';