Granting access to a Sequence

From: Kevin Bass <akil1_at_mindspring.com>
Date: Sat, 20 Feb 1999 01:15:14 GMT
Message-ID: <7al2cu$m9j$2@camel19.mindspring.com>

I am attempting to grant select access to sequence called sq_cmnt_no_01 but has receive the following error:

grant select to sq_expat_cmnt_no_01 to public

ERROR at line 1:
ORA-00990: missing or invalid privilege

I have the following system privilege as a DBA:

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
SYSTEM                         DBA                            YES YES

How can I get around this error and grant select access to this sequence (if possbile)? Received on Fri Feb 19 1999 - 19:15:14 CST