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.