createuser.sql

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· SQL 代码 · 共 5 行

CREATE USER "DKTEST"  PROFILE "DEFAULT" IDENTIFIED BY "dktest" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" 
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "DKTEST";
GRANT "RESOURCE" TO "DKTEST";