Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem creating table with new account

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.

  1. Create your own tablespace or use the Oracle created tablespace for users named "USERS"
  2. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US