1.创建表空间
CREATE TABLESPACE TLKHDBZzgl
LOGGING
DATAFILE 'D:/data/TLKHDBZzgl.ORA' SIZE
50M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED;
2.创建用户
CREATE USER user_zzgl IDENTIFIED BY zzgl DEFAULT TABLESPACE TLKHDBZzgl;
3,授权用户
GRANT CONNECT,RESOURCE TO user_zzgl;
GRANT dba TO user_zzgl;