Re: Granting access to a Sequence

The correct syntax is:

grant select ON sq_expat_cmnt_no_01 to public

             ^^ - !!!

Hope this helps.

Kevin Bass wrote:
>
> CORRECTION:
>
> I am 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)?

-- 
Valerie Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru