0 创建测试用户
create user soctt identified by 11 ;
grant dba to scott;
create user one identified by 11 ;
1 角色role
select * from dba_roles;
select * from user_role_privs;
select * from dba_role_privs where grantee = 'SCOTT' ;
select * from dba_role_privs where grantee = 'ONE' ;
2 权限privilege
system_privilege和table_privilege
select * from system_privilege_map order by name;
select * from table_privilege_map;
select * from role_sys_privileges;
select * from role_tab_privileges;
授予、回收系统权限(user_sys_privs)
sqlplus one/ 22
grant create session to one;
revoke create session from one;
create table t1 . . .
grant create table to one;
create table t1 . . .
grant UNLIMITED TABLESPACE to one;
select * from user_sys_privs;
select * from dba_sys_privs where grantee = 'ONE' ;
select * from dba_sys_privs where grantee = 'DBA' order by privilege;
授予、回收对象权限(user_tab_privs)
grant select , update on scott. t1 to one;
revoke update from scott. t1 from one;
select * from scott. t1;
select * from user_tab_privs;
select * from dba_tab_privs where grantor = 'SCOTT' ;
select * from all_tab_privs where grantee = 'ONE' ;
参考: https://www.cnblogs.com/lichuangblog/p/6892931.html