OraFAQ Forum: Server Administration » Can't create index as user

Home » RDBMS Server » Server Administration » Can't create index as user (Oracle 9.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't create index as user [message #288263]

Sun, 16 December 2007 16:02

yosial
Messages: 1
Registered: December 2007

Junior Member

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?

Report message to a moderator

Re: Can't create index as user [message #288271 is a reply to message #288263]

Sun, 16 December 2007 20:22

Barbara Boehmer
Messages: 9100
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.

Report message to a moderator

Previous Topic:	Bubble Fragmentation
Next Topic:	How to remove this job?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:51:06 CST 2024