给oracle添加一个帐号

例子：

 

如果我们现在需要创建一个用户名为：TTTTT

密码为：TEST

的用户，则可以使用以下语句：

---

CREATE USER "TTTTT" IDENTIFIED BY "TEST";

GRANT "CONNECT" TO "TTTTT" WITH ADMIN OPTION;
GRANT "DBA" TO "TTTTT" WITH ADMIN OPTION;
ALTER USER "TTTTT" DEFAULT ROLE "CONNECT", "DBA";

COMMIT;