Re: grant privileges on tablespace

The user VIDEOEUL, must have priviledges on the tablespace indexes not system.

alter user VIDEOEUL quota unlimited on indexes;

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Terry Yeung" <terryyNOteSPAM_at_alum.calberkeley.org.invalid> wrote in message
news:068e12dc.98fbc8a2_at_usw-ex0106-046.remarq.com...


> In article

> <956330288.13576.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand

> Bakker" <postbus_at_sybrandb.demon.nl> wrote:

> >

> >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

>


>    I have the same problem as Manuel.  I created an INDEXES

> tablespace and I want to move some indexes over to that

> tablespace.  I login as the SYSTEM user and tried doing:

>


> ALTER INDEX VIDEOEUL.VIL_PK REBUILD TABLESPACE INDEXES STORAGE

> (INITIAL 4K NEXT 8K PCTINCREASE 0);

>


> but it gives me ORA-01950: no privileges on tablespace 'INDEXES'.

> I then tried what you suggested, the grant goes fine but when I

> try the Alter Index it gives me the same error.  Any ideas?

>


> -Terry

>
>
>


> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network

 *


> The fastest and easiest way to search and participate in Usenet - Free!

>