Re: Oracle Security? - What Gives?

I assigned the "create any sequence", etc. priviledges to the owner of the stored procedure. This worked.

Thanks,

Troy Perchotte

Dean Mah wrote:

> I'm using 7.3.4 and have only had to grant privileges to the owner of
> the stored procedure. I then grant execute permission to the role
> and all users granted that role can run the procedure.
>
> Regards,
> Dean
>
> Troy Perchotte wrote:
> >
> > I created a stored procedure that first drops and then creates a
> > sequence. It runs successfully; however, when I tested it from another
> > user's account, oracle returns an "insufficicient priveledges" error.
>
> [ snip ]
>
> > After speaking with oracle support, I was told that I had to grant the
> > "create any sequence" to each individual account, and that the role's
> > permission "doesn't work in this case".
Received on Mon Aug 31 1998 - 00:00:00 CDT