Oracle 用户管理

用户信息查询

• 查询当前用户被赋予的角色

select * from user_role_privs;

select * from dba_role_privs where grantee=username;

• 查看某个角色拥有的权限

• 查看当前用户拥有的权限

SQL> select distinct(privilege) from dba_sys_privs where grantee in (select granted_role from user_role_privs);

PRIVILEGE
--------------------------------------------------------------------------------
ALTER ANY CUBE DIMENSION
DROP ANY EDITION
ADMINISTER ANY SQL TUNING SET
EXECUTE ANY LIBRARY
CREATE ANY LIBRARY
...
202 rows selected.

SQL> 

新建用户

1. 新建用户
2. 给用户赋权限

create user user_name
identified by password
default tablespace tablespace_name
temporary tablespace TEMP;

grant role to user_name;