--表空间
CREATE TABLESPACE bieeweb DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 10G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
--索引表空间
CREATE TABLESPACE bieeweb_Index DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
--2.建用户
create user bieeweb identified by bieeweb001 default tablespace bieeweb;
--3.赋权
grant connect,resource to bieeweb;
grant create any sequence to bieeweb;
grant create any table to bieeweb;
grant delete any table to bieeweb;
grant insert any table to bieeweb;
grant select any table to bieeweb;
grant unlimited tablespace to bieeweb;
grant execute any procedure to bieeweb;
grant update any table to bieeweb;
grant create any view to bieeweb;
CREATE TABLESPACE bieeweb DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 10G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
--索引表空间
CREATE TABLESPACE bieeweb_Index DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
--2.建用户
create user bieeweb identified by bieeweb001 default tablespace bieeweb;
--3.赋权
grant connect,resource to bieeweb;
grant create any sequence to bieeweb;
grant create any table to bieeweb;
grant delete any table to bieeweb;
grant insert any table to bieeweb;
grant select any table to bieeweb;
grant unlimited tablespace to bieeweb;
grant execute any procedure to bieeweb;
grant update any table to bieeweb;
grant create any view to bieeweb;