2 Replies Latest reply: Oct 23, 2012 3:15 AM by 416401 RSS

    can not grant usage on sequence - error 00990. 00000

    416401
      As the owner of the sequence I need to give the usage privilege to other users, but it seems that although I am the owen, I can not grant it ??

      My script:

      DROP SEQUENCE SEQ_STRIZPITI;
      CREATE SEQUENCE SEQ_STRIZPITI INCREMENT BY 1 START WITH 1000000 ;
      GRANT USAGE ON SEQUENCE SEQ_STRIZPITI TO PUBLIC;

      And the result is:

      sequence SEQ_STRIZPITI dropped.
      sequence SEQ_STRIZPITI created.

      Error starting at line 3 in command:
      GRANT USAGE ON SEQUENCE SEQ_STRIZPITI TO PUBLIC
      Error report:
      SQL Error: ORA-00990: missing or invalid privilege
      00990. 00000 - "missing or invalid privilege"
      *Cause:   
      *Action:


      Please advise !