create bigfile tablespace TS_ssthjj_jhk --表空間

logging

datafile 'D:\app\Administrator\oradata\orcl\ssthjj_jhk_DATA.DBF'

size 5120m

autoextend on

next 1024m maxsize 10240m;

create user ssthjj_jhk --用戶名

identified by "S_%hjk76pog%3b" --密碼

default tablespace TS_ssthjj_jhk

profile DEFAULT;

-- Grant/Revoke role privileges

grant connect to ssthjj_jhk;

grant resource to ssthjj_jhk;

-- Grant/Revoke system privileges

grant create any trigger to ssthjj_jhk;

grant create session to ssthjj_jhk;

grant create table to ssthjj_jhk;

grant create view to ssthjj_jhk;

grant unlimited tablespace to ssthjj_jhk;