ORA-01950: no privileges on tablespace
918420Feb 18 2012 — edited Feb 18 2012Hi 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