Re: GRanting access to a Sequence

From: Van Messner <vmessner_at_netaxis.com>
Date: Sat, 20 Feb 1999 18:17:14 -0500
Message-ID: <MsHz2.2247$4_5.1167@news6.ispnews.com>

If the syntax is not the problem, remember you have to own the object to grant object privileges, so log in as the owner of the sequence.

Van

Serge wrote in message <7amu4p$g1n$1_at_news2.aha.ru>...
>grant select ON <something> to <somebody>;
>Ok?
>
>Kevin Bass wrote <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 - 17:17:14 CST