The rights have to be granted directly to the user not through roles
Arnold Schommer <aschommer_at_fs-edv.de> wrote in article
<35C585BF.3E6EECC3_at_fs-edv.de>...
> (please pardon the late response)
>
> Philippe wrote:
>
> > You have to grant "CREATE TABLE" privilege to the procedure owner. A
> > stored
> > procedure use the owner privileges, not the user privileges.
>
> That can not be the reason - in the particular case, the procedure owner
> and user were the same. (And both were allowed to create tables).
>
>
> > Arnold Schommer <aschommer_at_fs-edv.de> wrote in article
> > <35BF03D8.F202B33_at_fs-edv.de>...
> > > I have encountered the following strange situation: In order to
> > rebuild
> > > an table chosen by the user i used dynamic SQL via some own package
> > > calling the DBMS_SQL-Package; the instruction was something like
> > > CREATE TABLE schema.save_example AS (SELECT * FROM schema.example)
> > > (please don't focus on the schema and table names)
> > > Doing it this way i got the error ora-01031 on DBMS_SQL.PARSE().
> > Copying
> > > the SQL-instruction to SQL-worksheet, it worked. The same
> > instruction
> > > performed via FORMS_DDL() also succeeded.
> > >
> > > The Login was the same for Forms and SQL-worksheet, so what is the
> > > reason of this different behaviour ? Did i do something wrong ?
> > >
> > > I'm using Oracle Forms 4.5, the Database-Version is 7.3.2.2.0 (on
> > NT).
> > >
> > > Thanks in advance
> > >
> > > Arnold
> > >
>
Received on Tue Aug 04 1998 - 03:21:51 CDT
