oracle主题——用户

1、用户创建

create user CLOUD identified by 123456
default tablespace DATA_GLZX;

2、用户授权

grant connect,resource,dba to BURCE_LI;
grant create session to  BURCE_LI;
grant create table to  BURCE_LI;

3、用户删除

--仅删除用户
drop user USER_ORA_SQL ;
--删除用户及数据
drop user USER_ORA_SQL cascade;

4、用户查询

select * from dba_users;

5、修改用户密码

alter user sys identified by 123456;