Re: Newbie: problem with user access to tablespace

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 09 Apr 1999 04:26:38 GMT
Message-ID: <37115738.3743723@netnews.worldnet.att.net>

On Thu, 08 Apr 1999 12:19:36 -0500, Allan Tingey <al_at_ibis.genetics.utah.edu> wrote:

>1. Under what schema should your main tables be created and what
> needs to be done so that database users can access those tables?

Usually you setup one user to own the tables. No one actually connects using that user-id. It only exists to be an owner.

>2. Currently, only my system account can create tables in the
> tablespace I want to use. Other users get a "no privileges on
> tablespace" message when trying to create a table, even though
> this is their default tablespace.

Maybe you didn't grant quota on the tablespace. You have to tell Oracle how much space each user can use on each tablespace. You can grant a user unlimited quota:

alter user XXX quota unlimited on tablespace_name;

or you can limit them to a certain amount of space, say 5 meg:

alter user XXX quota 5m on tablespace_name

The schema owner is the one who needs the quota. Application users typically do not.

>What do I need to do to these
> accounts so they can work with tables in their default tablespace?
Received on Thu Apr 08 1999 - 23:26:38 CDT