Re: Hate to keep bugging...but newbie still needs help!

Bob

By default, users don't have access to any tablespaces. You need to grant the user you want to create the table a quota on the tablespace. This is done by either:

alter user testing quota 10m on tablespace testing; or alter user testing quota unlimited on tablespace testing;

You may also want to change their default and temporary tablespaces thus:

alter user testing default tablespace testing temporary tablespace temp:

From your message it's not clear whether you are using the syntax create table testing.table_name when logged on as SYSTEM, or create table table_name when logged on as TESTING. In either case, the user who owns the table is the one who needs access (not SYSTEM as in my first example).

HTH. Pete

Robert Britton wrote:

> Ok...I install Oracle 8.0.5 on NT.
> run catalog.sql, catproc.sql.
>
> Log on as system/manager.
>
> Create user called "Testing"
>
> trying to create a table on Testing table space and it gives me
>
> error ORA-1950 access denied to tablespace "Testing"
>
> (I created a table space called Testing , too)
>
> How can the SYSTEM manager be denied access to a table he created?
>
> Sorry to be a newbie here, but I just can't figure this out.
>
> If I created the user and the table space, how to I grant myself access to
> that table space?
>
> bob_at_themicrocenter.com

--

Regards

Pete

Received on Mon Jun 07 1999 - 15:01:24 CDT