This discussion is archived
2 Replies Latest reply: Oct 23, 2012 1:15 AM by 416401 RSS

can not grant usage on sequence - error 00990. 00000

416401 Newbie
Currently Being Moderated
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 !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points