----------------------------------------------------------------------------------
-- Create the user cdsp
create user cdsp
identified by oracle
default tablespace TS_SP_DAT
temporary tablespace TEMP
profile DEFAULT
/
-- Grant/Revoke role privileges
grant connect to cdsp
/
--grant dba to cdsp;
grant resource to cdsp
/
-- Grant/Revoke system privileges
grant unlimited tablespace to cdsp;
grant create any view to cdsp
/
create tablespace TS_SP_DAT
logging
datafile 'C:\oracle\product\10.2.0\oradata\bentu\TS_SP_DAT.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local autoallocate;