Oracle的用户、角色及权限相关操作

create user KD identified by 123456;

grant connect to KD;

grant select on scott.emp to KD;
grant create table to KD;

revoke select on scott.emp from KD;

grant select,inset,delete,update on scott.emp to KD;
revoke select,inset,delete,update on scott.emp from KD;

drop user KD;

drop user KD cascade;

select * from session_privs;

select * from user_role_privs;

select * from dba_sys_privs;
select * from dba_sys_privs where grantee='CONNECT';
--create session
select * from dba_sys_privs where grantee='RESOURCE';
/*
create trigger 
create sequence 
create type 
create procedure 
create cluster 
create operator 
create indextype 
create table
*/
select * from dba_sys_privs where grantee='DBA';
--有最高权限 所有的权限都有

create user CURRY identified by 123456;
create connet,resource to CURRY;

alter user HR account unlock;

alter user HR identified by 123456;