简单的创建用户命令:
create user jiao identified by jiao;
锁定账户:
alter user jiao account lock;
解锁账户:
alter user jiao account unlock;
修改密码:
alter user jiao identified by jiao;
显示当前用户:
show user;
删除用户及其对象:
drop user jiao cascade;
查询用户名:
select * from dba_users;