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;