Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GRanting access to a Sequence
CORRECTION: I was attempting to grant select access to sequence called sq_expat_cmnt_no_o1 and not a sequenc called esq_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)?
"Prakash Bandaru" <pbandaru_at_erols.com> wrote:
>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 Sat Feb 20 1999 - 07:20:55 CST