createtempuser-1.sql

来自「Oracle 9i中文版基础培训教程」· SQL 代码 · 共 7 行

CREATE USER "TEMPUSER"  PROFILE "DEFAULT" 
    IDENTIFIED BY "tempuser" DEFAULT TABLESPACE "USERS" 
    ACCOUNT UNLOCK;
GRANT CREATE ANY TABLE TO "TEMPUSER" WITH ADMIN OPTION;
GRANT "CONNECT" TO "TEMPUSER" WITH ADMIN OPTION;