Oracle用户授权
一.用户授权
1)普通权限
grant ${autoType1, autoType2, autoType3, ...} to ${userName} identified by ${password};
例1: grant connect, resource to scott identified by tiger; -- 可以不带后面的"identified by 密码"部分
例2: grant create view to scott;
2)dba权限
grant sysdba to ${userName};
3)导入数据库权限
grant imp_full_database to ${userName};
4)查看用户拥有的角色
select * from dba_role_privs where grantee='${用户名}';
5)查看角色拥有的权限
select * from role_sys_privs where role = '${角色名}';
6)查看当前用户所有权限
select * from user_sys_privs;