Hi all,

I have created a sequence in my one oracle schema xyz.
I have given grant to abc schema.
   grant all seq_name to abc.
Now if I am writting
   select seq_name.nextval from dual
in abc schema.
But getting the error
"sequence does not exist"

I hope I m clear.

Pl help.


Rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

Yes you are missing the Grant, Use
Grant select on seq_name to user_name;