查询对象类型:
select distinct object_type from dba_objects;
查询用户:
select * from dba_users;
授予用户权限:
grant connect,resource to u1;
(一般授予这两个,登录连接会话和使用资源)
查询系统所有权限:
select * from session_privs;
查询系统所有角色:
select * from session_roles;
查询用户权限:
select * from user_sys_privs;
查询用户角色权限:
select * from role_sys_privs;