create_user.sql

来自「Oracle Advance Queue(AQ)的使用例子」· SQL 代码 · 共 12 行

DROP USER aquser CASCADE;
CREATE USER aquser IDENTIFIED BY aquser
    DEFAULT TABLESPACE tab
    TEMPORARY TABLESPACE temp
    QUOTA 0 ON system
    QUOTA UNLIMITED ON tab
    PROFILE default;
--
GRANT my_aq_user_role TO aquser;
--
EXIT;