Also make sure that the target schema has quota on the tablespace where you
are creating the tables.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message
news:3B4CC969.D129E29F_at_attws.com...
> Raman Ohri wrote:
>
> > My team and I are new to the Oracle world. We are trying to work
> > together on the development of a database with oracle 9i standard. The
> > database is pretty "plain", at least so far; we aren't using any
> > advanced features, just trying to create some tables.
> >
> > We would like to be able to log in with our own user names and create
> > schema objects under a single target schema. The account attached to
> > that target schema is the account that will be used by an external
> > application.
> >
> > When we log in under our own accounts, we cannot create tables that
> > live in the target schema; getting IRA-01031: insufficient privileges.
> > We checked the help on this and it says we need to have certain privs
> > or have the dba role. Just as a quick test, we gave ourselves the dba
> > role, but we still get the same error.
> >
> > What are we doing wrong?
> >
> > Platform info:
> > oracle 9i server running on suse linux box
> > oracle enterprise manager 2.2.0.0.0 running on win2k workstations
> >
> > thanks,
> > Raman
>
> You need the privilege CREATE ANY TABLE. And be sure when creating objects
> you specify the schema_name dot object_name.
>
> Daniel A. Morgan
>
Received on Wed Jul 11 2001 - 17:04:43 CDT
