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 con,resource to CURRY;

alter user HR aount unlock;

alter user HR identified by 123456;