I have a brand new Oracle database that is giving the error:
ORA-01950: no privileges on tablespace 'USERS'
I have done:
alter user kainaw quota 100M on 'USERS'; grant unlimited tablespace to kainaw;
Still, a single insert returns that error. Other than disk quota, what else causes the "no privileges on tablespace 'USERS'" error?
Oracle version is 220.127.116.11.0 (11g). I am logging in from the command prompt on the server. So, I alter user kainaw as sysdba. Then, I logout and login a user kainaw to test:
insert into i.test values (1);
Note: i.test is a table with only a number field. I get the error above. I logout as kainaw, login as sysdba, play with permissions, logout, login, test, error, logout, login, ...