Re: privileges on tablespace

From: <steveee_ca_at_my-deja.com>
Date: Wed, 06 Dec 2000 13:08:36 GMT
Message-ID: <90ldof$442$1@nnrp1.deja.com>

Hi,

Typically what you will do when you create a user is assign them a default 'working' tablespace to store the objects they create and a temporary tablespace for any temporary (usually sort) operations they may perform.

I'd suggest checking the full syntax for CREATE USER where it will detail the options available..if you haven't got yours set up the way you want you can use ALTER USER to correct it, or drop the user and re-create ..further, since you haven't specified the actual error, it could be a problem with other privileges that haven't been granted to the user..when you first create a user they have no privileges to do anything..

I hope this is of some help

Steve

In article <te94s0hvmjn.fsf_at_seipcc25.saclay.cea.fr>, Jean-Paul Le Fevre <J-P.LeFevre_at_cea.fr> wrote:
>
> A newbie question :
>
> I've just installed Oracle on my Linux box.
> I've granted right to create table to user Joe.
> However Joe is still unable to create his table since
> he has no privileges on tablespace.
>
> Which tablespace should he use ?
> How to give him privilege to modify the tablespace ?
>
> Thank you,
>
> --
>

>
> Jean-Paul Le Fèvre * CEA Saclay DAPNIA/SEI * Mail :
Jean-Paul.LeFevre_at_cea.fr
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 06 2000 - 07:08:36 CST