1、创建用户
create user {username} identified by {password};
2、修改密码
alter user {username} identified by {password};
3、分配表空间
alter user {username} default tablespace {tablespace};
4、授权
grant connect to {username};
grant select on {tablename} to {username};