Re: GRanting access to a Sequence

From: <chuckh_at_safeplace.net>
Date: Mon, 22 Feb 1999 14:31:18 GMT
Message-ID: <7arpnn$2di$1@nnrp1.dejanews.com>

The correct format is:

grant select ON sq_expat_cmnt_no_01 to public;

In article <7al2dj$m9j$3_at_camel19.mindspring.com>, akil1_at_mindspring.com wrote:
> 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)?
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 08:31:18 CST