create user cjl identified by "123456";
GRANT CONNECT TO "cjl";
GRANT CREATE TRIGGER TO "cjl";
GRANT DEBUG CONNECT SESSION TO "cjl";
GRANT CREATE SEQUENCE TO "cjl";
GRANT CREATE TABLE TO "cjl";
GRANT CREATE PROCEDURE TO "cjl";
GRANT CREATE SYNONYM TO "cjl";
GRANT CREATE VIEW TO "cjl";
GRANT DEBUG ANY PROCEDURE TO "cjl";
上面的句子就可以建立一个用户名为cjl,密码为123456的用户,其实和平时建立没什么区别。