Re: Unable to create objects in other user schema

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 - 16:47:21 CDT