Oracle的用户、角色及权限相关操作_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;