Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01950: no privileges on tablespace

918420Feb 18 2012 — edited Feb 18 2012
Hi u all :)

I keep getting a no privileges error message every time i try to execute a procedure that suppose to insert data to different tables on different tablespaces.
When i created the user i gave him a default tablespace, and after it was created i also gave him the following privs :

SYS >grant unlimited tablespace to MGR;
SYS >ALTER USER MGR
2 QUOTA UNLIMITED ON TEL_AVIV_TBS;
SYS >ALTER USER MGR
2 QUOTA UNLIMITED ON JERUSALEM_TBS;

And still every time I try to execute the procedure i get :
Error report:

ORA-01950: no privileges on tablespace 'JERUSALEM_TBS'
ORA-06512: at "VOTE.VOTING_PROC", line 14
ORA-06512: at line 14
01950. 00000 - "no privileges on tablespace '%s'"
*Cause: User does not have privileges to allocate an extent in the
specified tablespace.
*Action: Grant the user the appropriate system privileges or grant the user
space resource on the tablespace.

I checked the OEM interface and see the following:

General
Name MGR
Profile DEFAULT_PROFILE
Authentication Password
Default Tablespace ELECTION_MASTER_TBS
Temporary Tablespace TEMP
Status UNLOCK
Default Consumer Group None
Roles
Role Admin Option Default
MANAGER N Y
System Privileges
System Privilege Admin Option
CREATE SESSION N
EXECUTE ANY PROCEDURE N
INSERT ANY TABLE N
SELECT ANY TABLE N
UNLIMITED TABLESPACE N
Object Privileges
Object Privilege Schema Object Grant Option
INSERT ELECTION_MASTER JER_VOTES N
INSERT ELECTION_MASTER TA_VOTES N
Quotas
Unlimited Tablespace System Privilege granted

Please help :)))

Itzik
This post has been answered by Solomon Yakobson on Feb 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2012
Added on Feb 18 2012
15 comments
152,769 views