Error report - ORA-01950: no privileges on tablespace 'USERS'

Question

I'm getting this error:

Error report - ORA-01950: no privileges on tablespace 'USERS' enter image description here

I created a new tablespace HR from HR Schema and I'm able to create tables, however, they do not show at the objects tab in Toad. I cannot insert anything into tables I created and the tables of HR Schema. The data in the tables of Schema isn't showing as well.

enter image description here

I tried this: ALTER USER quota unlimited on ; enter image description here

Still, I am getting error's as:

Error starting at line : 19 in command - ALTER USER hr quota unlimited on users Error report - ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to perform a database operation without the necessary privileges. *Action: Ask your database administrator or designated security administrator to grant you the necessary privileges enter image description here

Help me, to solve this Error Thank you

Answer 1

Based on screenshots you posted, it seems you didn't pay attention to output of commands you ran. All of them ended up with insufficient privileges.

It means that you can't perform those alter user this and that when you're connected as current user - they have to be performed by a privileged user (such as SYS, if you don't have any other with appropriate DBA privileges).

Therefore: connect as SYS and re-run command you used to grant privileges to hr.