oracle_create

服务器端操作 1、以系统用户登陆 >sqlplus sys/密码 as sysdba; 2、创建表空间 sql>create tablespace wwspace datafile 'D:\wwOracle\wwspace.dbf' size 10M; 3、创建用户并制定表空间 sql>create user wwuser identified by wwuser default tablespace wwspace temporary tablespace temp 位置：D:\wwOracle\wwspace.dbf 用户名: wwuser 密码: wwuser 临时表：temp 3、创建角色 sql>create role wwrole; 4、给角色赋予相应权限 sql>grant create session,alter session,create view,create anytable to wwrole; sql>grant connect,resource to wwrole; sql>grant dba to wwrole; 5、把角色赋予用户 sql>grant wwrole to wwuser;