玖叶教程网

select * from dba_users; 查询数据库中的所有用户

alter user TEST_SELECT account lock; 锁住用户

alter user TEST_SELECT account unlock; 给用户解锁

create user xxxx identified by xxxx; 建立用户

grant create tablespace to xxxx; 授权

grant select on tabel1 to xxxx; 授权查询

grant update on table1 to xxxx;

grant execute on procedure1 to xxxx 授权存储过程

grant update on table1 to xxxx with grant option; 授权更新权限转移给xxxx用户，许进用户可以继续授权；

收回权限

revoke select on table1 from xxxx1; 收回查询select表的权限；

revoke all on table1 from xxxx;

select table_name,privilege from dba_tab_privs where grantee='xxxx' 查询一个用户拥有的对象权限

select * from dba_sys_privs where grantee='xxxx' 查询一个用户拥有的系统权限

select * from session_privs 当钱会话有效的系统权限

角色

create role xxxx1;建立xxxx1角色

grant insert on xezf.cfg_alarm to xxxx1; 将插入表的信息

revoke insert on xezf.cfg_alarm from xxxx1; 收回xxxx1角色的权限

grant xxxx1 to xxxx ; 将角色的权限授权给xxxx;

create role xxxx2;

grant xxxx1 to xxxx2; 将角色xxxx1授权给xxxx2;

alter user xxxx default xxxx1,xxxx2; 修改用户默认角色

DROP ROLE xxxx1;删除角色1；

select * from role_sys_privs where role=xxxx1;

查看许进1角色下有什么系统权限；

select granted_role,admin_option from role_role_privs where role='xxxx2';

查看xxxx1角色下面有什么角色权限

select * from role_sys_privs where role='xxxx2';

select table_name,privilege from role_tab_privs where role='xxxx1';

select * from dba_role_privs where grantee='xxxx' 查看用户下面有多少个角色；