create user cxuser01 identified by test123  default tablespace USERS temporary tablespace TEMP;

--创建用户

 

grant connect,resource,select any table,select any dictionary,create any synonym to cxuser01;

赋权连接、查询所有表、字典及创建同义词（表别名）权限

 

revoke unlimited tablespace from cxuser01;

--撤销可以在其他表空间随意建表权限

alter user cxuser01 identified by "cxuser01";

--修改用户密码

 

如果需要修改表权限

grant insert,update,select,delete on scott.test to cxuser01;

--增加test表的增删改查权限