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 sessionselect * 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;