Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: grant privileges on tablespace
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
![]() |
![]() |