Re: Problem creating table with new account

From: <faheemrao_at_my-deja.com>
Date: Mon, 21 Aug 2000 07:08:41 GMT
Message-ID: <8nqkhh$hd1$1@nnrp1.deja.com>

Dear

First of all , you have created yor own user on system tablespce , which is not recomended,
You sholud change your user default tablespace by the following steps.

Create your own tablespace or use the Oracle created tablespace for users named "USERS"
Issue the folowing command to change your default tablespace at sql prompt

      Sql> alter user <user_name>
      sql> defaut tablespace USERS
3.   Then issue the following command to grant you quota on your
     default tablespace.

     sql> grant resource to "user_name".

Please ask againg if you have any problem.

Faheem Rao

In article <966699582.732057749_at_news.rete039.it>, root <root_at_localhost.localdomain> wrote:
> Hello all,
>
> I have created a new account in a Oracle 8.5.0 DB giving all
privileges for
> creating tables.
> When I logon and execute the CREATE TABLE command I get the error
message
> saying that I don't have privileges on SYSTEM tablespace.
> What is the problem ?
> Thanks a lot.
>
> Marco Mapelli
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 02:08:41 CDT