ORACLE CREATE USER

sanshou

于 2014-02-26 11:15:15 发布

阅读量7.1k

点赞数

分类专栏： DATABASE

本文链接：https://blog.youkuaiyun.com/sanshou/article/details/19969837

版权

DATABASE 专栏收录该内容

29 篇文章

订阅专栏

CREATE USER "AAA"  PROFILE "DEFAULT" 
    IDENTIFIED BY "AAA" DEFAULT TABLESPACE "USER" 
    TEMPORARY TABLESPACE "TEMP" 
    QUOTA UNLIMITED 
    ON "USER" 
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "AAA";
GRANT "RESOURCE" TO "AAA";
GRANT "DBA" TO "AAA";