Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> GRanting access to a Sequence

GRanting access to a Sequence

From: Kevin Bass <akil1_at_mindspring.com>
Date: Sat, 20 Feb 1999 01:15:36 GMT
Message-ID: <7al2dj$m9j$3@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:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US