创建过程:
* 创建Oracle用户
create user user1 identified by user1;
* 查看用户
select * from dba_users;
* 创建表空间
create tablespace ts_user1 datafile 'f:\user1.dbf' size 100m;
* 查看表空间
select * from dba_tablespaces;
* 将用户的表空间修改为ts_user1
* alter user user1 default tablespace ts_user1;
* 为用户授权
* grant create session, create table, unlimited tablespace to user1;
* 查看当前用户拥有的权限
* select * from session_privs;