can not grant usage on sequence - error 00990. 00000
416401Oct 19 2012 — edited Oct 23 2012As 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 !