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 126.96.36.199.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, ...
ihave privs on the tablespace
USERS, because it needs them rather than the user
kainawneeding them -
t own the table,i` does.
iowns the table, therefore user
ineeds to be granted a quota on the
iIS still a user that exists in the database. In Oracle Schema=User (at least until 12c came along). That`s the way it works - the owner of the table needs the grants, not the user that is actually inserting the data (because that makes no sense!).