oracle数据库创建用户

oracle数据库如何创建用户：

a.创建用户：

create user cms identified by cms;

b.创建表空间：
create tablespace ts_cms datafile 'D;\hikcms\cms_data.dbf' size 100m;
将表空间分给用户
c.alter user cms default tablespace ts_cms;
d.给用户授权:
grant create  session,create  any table ,create  any view ,create any sequence,create any procedure,create any job,unlimited tablespace to cms3;
e.以cms用户登录.
conn cms/cms.