刚才把最下面的改一下:
CREATE USER 用户 IDENTIFIED BY 用户密码;
COMMIT;
GRANT DBA, CONNECT TO 用户; 授权用户
ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
ALTER USER test TEMPORARY TABLESPACE temp;
COMMIT;
刚好学了这个。
CREATE USER 用户 IDENTIFIED BY 用户密码;
COMMIT;
GRANT DBA, CONNECT TO 用户; 授权用户
ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
ALTER USER test TEMPORARY TABLESPACE temp;
COMMIT;