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;