insufficient privileges when i create a tablespace in user flshop

[alituri]

how to grant all privileges to my created user "flshop".

SQL> connect flshop/admin;
Connected.
SQL> create tablespace shoptb
2 datafile
3 'E:\oracle\product\10.2.0\flash_recovery_area\shop tb_01.dbf' SIZE 200M autoextend off,
4 'E:\oracle\product\10.2.0\flash_recovery_area\shop tb_02.dbf' SIZE 200M autoextend off
5 logging
6 extent management local;
create tablespace shoptb
*
ERROR at line 1:
ORA-01031: insufficient privileges

[PreethiGowri]

try this command
"Grant create session, grant any privilege to 'user_name'; "
also refer this site for your reference

[rski]

GRANT CREATE TABLESPACE TO flshop;
 

[arumurali]

GRANT your created workspace to user;