Privileges on Tablespace

As salamo alaikum wa rahmatullah,

Provide the Privileges on Tablespace.

Situation :- I have created a user by name test_user and try to create a table with big data an error is thrown by the oracle like "no privileges on tablespace system", here is step by step solution of this.

[Windows Operating System]
C:\windows\system>Sqlplus "/ as sysdba"
Sql> show user
"SYS"

sql> create user test_user identified by test_user Quota unlimited on users tablespace system;

sql> grant connect, create table to test_user;

sql>connect test_user/test_user
sql> Create table My_Table As select * from all_objects;

Oracle error -> no privileges on tablespace system.

sql> connect sys as sysdba
password : *******
sql> Alter user test_user Quota 100M On system;
sql>Grant unlimited tablespace to test_user;
sql> connect test_user/test_user
sql>Create table My_Tables AS Select * from all_objects;
Table created

--
Mohammad Shahnawaz
Oracle's Passion