Unable to create objects in other user schema

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 Received on Wed Jul 11 2001 - 16:31:23 CDT