Home » RDBMS Server » Server Administration » Can't create index as user (Oracle 9.2.0.4)
Can't create index as user [message #288263] Sun, 16 December 2007 16:02 Go to next message
yosial
Messages: 1
Registered: December 2007
Junior Member
Sad I created a user and granted him these privileges:

USER PRIVS
--------------------------------------------------------------------------------
YOSI
ALTER TABLESPACE
CREATE ANY INDEX
CREATE ANY TABLE
CREATE SESSION
CREATE TABLE
CREATE TABLESPACE
DROP ANY TABLE
INSERT ANY TABLE
MANAGE TABLESPACE
SELECT ANY TABLE

When I try to create an index by this user, I get an error

SQL> /
create index table5_col1_index on yosi.table5(col1) tablespace yosi2tablespace
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'YOSI2TABLESPACE'

When I run this command as 'system', it is successful

What is wrong?

Re: Can't create index as user [message #288271 is a reply to message #288263] Sun, 16 December 2007 20:22 Go to previous message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
you need to assign a quota on the tablespace, like:

ALTER USER yosi QUOTA 100M ON yosi2tablespace;

or

ALTER USER yosi QUOTA UNLIMITED ON yosi2tablespace;

You can assign unlimited tablespace or a number of megabytes or kilobytes.
Previous Topic: Bubble Fragmentation
Next Topic: How to remove this job?
Goto Forum:
  


Current Time: Sun Dec 04 12:50:18 CST 2016

Total time taken to generate the page: 0.08528 seconds