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



Wed, 18 Jun 1902 08:00:00 GMT
 grant privileges on tablespace



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



Wed, 18 Jun 1902 08:00:00 GMT
 grant privileges on tablespace
In article

Quote:



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



Wed, 18 Jun 1902 08:00:00 GMT
 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

remove nospam from reply address
http://24.8.218.197/

Quote:
> In article




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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. how to Grant the Act as part of the operating system privilege in windows 2000

2. Granting a database user SA privileges

3. how to script-wise grant access privilege to a user

4. [HACKERS] Re: Re: grant privileges to a database [URGENT]

5. grant privileges to a database [URGENT]

6. Grant privileges to database

7. grant privileges to a database

8. grant privileges to all tables with wildcard?

9. Grant object privileges problem

10. system privilege granting


 
Powered by phpBB® Forum Software