create tablespace EWMSDB datafile 'E:/EWMSDB/ewms.dbf' size 100M autoextend on next 10M maxsize unlimited extent management local;
create user 'ewmsdb' identified by 'ewmsdb' defalut tablespace EWMSDB;
create user ewmsdb identified by ewmsdb defalut tablespace myspace;
-- Create the user
create user EWMSDB
identified by "EWMSDB"
default tablespace EWMSDB
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to EWMSDB;
grant exp_full_database to EWMSDB;
grant imp_full_database to EWMSDB;
grant resource to EWMS;
-- Grant/Revoke system privileges
grant unlimited tablespace to EWMSDB;
create user 'ewmsdb' identified by 'ewmsdb' defalut tablespace EWMSDB;
create user ewmsdb identified by ewmsdb defalut tablespace myspace;
-- Create the user
create user EWMSDB
identified by "EWMSDB"
default tablespace EWMSDB
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to EWMSDB;
grant exp_full_database to EWMSDB;
grant imp_full_database to EWMSDB;
grant resource to EWMS;
-- Grant/Revoke system privileges
grant unlimited tablespace to EWMSDB;