Re: stored proc to create sequence, insufficent priv

From: Ken Chesak <datavector_at_hotmail.com>
Date: 25 Apr 2003 13:40:51 -0700
Message-ID: <3f2f39c4.0304251240.2ffae336@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message >
> This question has been asked over and over and over and over again,
> preferably by people, who didn't any research of their own before
> posting on metalink or on the newsgroups archives at
> http://groups.google.com
>

I googled this till my eyeballs fell out.

> The answer is you have create sequence privilege through a role, and
> roles are ignored during compilation of stored procedures, as they are
> volatile.

Thank you good information.

> Depending on version (which you too fail to mention) either
> grant create sequence directly (8.0 and lower) or create the procedure
> with authid current_user.

My mistake, 8.1.7

> And PLEASSSSSSSSSSSSSSSSE ALLLLLLLLLLLLLLWAYS search the archives
> BEFORE posting, to avoid getting ignored with these FAQs
>

I alwayssssssssssss dooooooooooooo.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Apr 25 2003 - 15:40:51 CDT