PLS-00201 DBMS_AQ 看不到问题

来源:互联网 发布:金十数据那个版本好用 编辑:程序博客网 时间:2024/04/29 20:30
建一个存储过程时报错,
4/19 PLS-00201: identifier 'DBMS_AQ' must be declared
4/19 PL/SQL: Item ignored
5/22 PLS-00201: identifier 'DBMS_AQ' must be declared
5/22 PL/SQL: Item ignored
7/11 PLS-00201: identifier 'PABSE_AQADMIN.MESSAGE_TYP' must be
declared
用到了dbms_aq包,需要对AQ USER,AQ ADMIN用户进行授权, 格式如下

SYS>grant execute on DBMS_AQ to my_username;
GRANT RESOURCE TO <UserName>;
GRANT CONNECT TO <UserName>;
GRANT EXECUTE ANY PROCEDURE TO <UserName>;
GRANT aq_administrator_role TO <UserName>;
GRANT aq_user_role TO <UserName>;
GRANT EXECUTE ON dbms_aqadm TO <UserName>;
GRANT EXECUTE ON dbms_aq TO <UserName>;
GRANT EXECUTE ON dbms_aqin TO <UserName>;
0 0
原创粉丝点击