创建用户
create user hgaong identified by pwdhgaong;
修改密码
alter user hgaong identified by hgaong;
表空间
查看表空间
select username,default_tablespace from dba_users;
创建表空间
create tablespace hgaong datafile 'f:\ts_zzg\zzg_data.dbf' size 200M;
分配表空间
alter user hgaong default tablespace hgaong;
用户授权
grant create session,create table,create view,create sequence,unlimited tablespace to hgaong;
登录