Re: Newbie: problem with user access to tablespace

You also need to give the users quotas on the tablespace you want the tables in. Alter user username
quota unlimited on tablespace_name;

You have to grant quotas as system.

Bill

TurkBear wrote:

> First - Do not create anything in the system tablespace ....Leave that for
> Oracle created stuff only....
>
> Then,
> Create a user for yourself to use as the DBA ( grant it all priviliges - see
> manual )
>
> Create a tablespace ( other than system ) for holding the tables
>
> Build the tables in this tablespace
> Create public synonyms for the tables
> ( i.e. create public synonym mynewtable for mydbausername,mynewtable )
> Grant priviliges on this synonym to the user(s)
>
> If you want to allow users to create tables then create a tablespace for them
> and make it their default tablespace ( grant resource on that tablespace to
> user(s) )
>
> Hope it helps,
> ( The Server Administrator's guide is a good source for info about managing your
> server)
>
> Hope it helps,
>
> Allan Tingey <al_at_ibis.genetics.utah.edu> wrote:
>
> >Hi,
> >
> >I have a lot of experience with computers but I am new to oracle...
> >
> >I have recently set up an 8.0.3 server on a Dec(Compaq) Alpha
> >server. Created a database with tablespace, etc...
> --------------snip----------------------------
> >
> >1. Under what schema should your main tables be created and what
> > needs to be done so that database users can access those tables?
> >
> >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. What do I need to do to these
> > accounts so they can work with tables in their default tablespace?
> >
> >Thanks for your help.
> >Please reply to al_at_howard.genetics.utah.edu (or post in newsgroup).
> >My al_at_ibis address sometimes fails.
> >
> >Allan Tingey
>
> To reply please remove the 'nospam' part of the address

--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207 Received on Thu Apr 08 1999 - 13:49:34 CDT