oracle新建登录用户sql语句

CREATE TABLESPACE TEST_DB
DATAFILE '/mnt/data/oracledata/TEST_DB .dbf' SIZE 5000M AUTOEXTEND ON
UNIFORM SIZE 128k;

CREATE TEMPORARY TABLESPACE TEST_DB_TEMP_DB
TEMPFILE '/mnt/data/oracledata/TEST_DB_TEMP_DB.dbf' SIZE 50M;

create user TEST_DB identified by 123456 default tablespace TEST_DB temporary tablespace TEST_DB_TEMP_DB;

grant connect,resource,dba to TEST_DB;

项目管理小测试数据库：TESTZYXMGL_9999  123456
10.75.142.242:1521/orcl  XMGL_BS_DBBACK