Re: Help cannot call a sequence

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/16
Message-ID: <01bcc2b7$60ee3980$54110b87@clamagent>#1/1

The owner of the sequence must grant select on the sequence to whomever is going to use it. As in "grant select on myschema.this_sequence to public;" The user must receive the grant, not a role. PL/SQL won't recognize permissions granted via a role.
- Dan Clamage dclamage AT idcomm DOT com (anti-spam format)

Terry Shores <tshores_at_asheboro.com> wrote...
> > Hi, i have a problem on oracle7,
> > If i refer to a sequence, say, mysequence.NextVal from PL/SQL it
> > works fine. If i try to address the same sequence from a function
> > (defined within a package) oracle complains about the non-existence
> > of this sequence (even if i spell it out as <user>.<sequence>.NextVal,
> > how do i solve this?
> >
> try creating a public synonym for the sequence... it should work in
> the same manner as a global variable.
Received on Tue Sep 16 1997 - 00:00:00 CDT