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 -> Re: GRanting access to a Sequence

Re: GRanting access to a Sequence

From: Prakash Bandaru <pbandaru_at_erols.com>
Date: Fri, 19 Feb 1999 22:23:39 -0500
Message-ID: <7ala54$e4u$1@winter.news.rcn.net>


It should be grant select on sq_expat_cmnt_no_1 to public

prakash
Kevin Bass wrote in message <7al2dj$m9j$3_at_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 - 21:23:39 CST

Original text of this message

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