create tablespace xzsp_nt_test
logging
datafile 'D:\oracle\product\10.2.0\test_data_nt_test.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create temporary tablespace test_temp
tempfile 'D:\oracle\product\10.2.0\test_data_nt_test_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create user nt_test identified by "123456" default tablespace xzsp_nt_test temporary tablespace test_temp;
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO nt_test;
grant dba to nt_test;
logging
datafile 'D:\oracle\product\10.2.0\test_data_nt_test.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create temporary tablespace test_temp
tempfile 'D:\oracle\product\10.2.0\test_data_nt_test_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create user nt_test identified by "123456" default tablespace xzsp_nt_test temporary tablespace test_temp;
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO nt_test;
grant dba to nt_test;