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: grant privileges on tablespace

Re: grant privileges on tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/21
Message-ID: <956330288.13576.0.pluto.d4ee154e@news.demon.nl>#1/1

super <manuel_at_datasail.it> schreef in berichtnieuws 8dpkh6$18jo$1_at_stargate1.inet.it...
> Hello,
> i have a tablespace users where i can't create table
> also if i am sysdba. How can i grant create table to user on tablespace ?
> This user tha i am using to create tablespace have default tablespace
> users
>
> Thank's a lot Manuel
>
>
>

This should have to do with tablespace quota not privileges. Try
alter user <youruser> quota unlimited on users:

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Apr 21 2000 - 00:00:00 CDT

Original text of this message

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