Re: Sequence problem driving me crazy

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: 2000/06/07
Message-ID: <393E9E67.97ED2ED@Unforgetable.com>#1/1

"Thomas J. Kyte" wrote:
>
> Who is doing the grant? Is it XYZ or someone else. I'm going to guess
> its someone else. And that someone else has NOT been granted select on
> xyz.myseq WITH GRANT OPTION. Consider this chain of events:
>

I think there is a gremlin somewhere. Yesterday it wasn't working, today it is.

Yesterday I tried doing the grant as XYZ and got the 1031 error. That is when I tried to do it as SYSTEM and got the 1031 error there as well. I ended up giving individual grants to each user. Now today I just tried it again and suddenly it worked. Somehow I must have been doing something different yesterday but I don't know what it was. Received on Wed Jun 07 2000 - 00:00:00 CDT