Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    6

    Unanswered: Issue with DBMS_ALERT package Help!!!

    HI Friends,
    I want to use the DBMS_ALERT package on "emp" table in scott. I have successfully run the DBMSALRT.SQL and PRVTALRT.PLB scripts
    connected as the user SYS. But when I connect as scott/tiger and use the DBMS_ALERT package on "emp" table. I get the message as identifier 'SYS.DBMS_ALERT' must be declared.
    Help!!!!!!!!!!!!!
    Avinash

  2. #2
    Join Date
    Jun 2002
    Posts
    2
    You have to grant execute privilege on sys.dbms_alert to scott

    connect sys
    grant execute on dbms_alert to scott;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •