how to grant all privileges to my created user "flshop".
SQL> connect flshop/admin;
Connected.
SQL> create tablespace shoptb
2 datafile
3 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_01.dbf' SIZE 200M autoextend off,
4 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_02.dbf' SIZE 200M autoextend off
5 logging
6 extent management local;
create tablespace shoptb
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> connect flshop/admin;
Connected.
SQL> create tablespace shoptb
2 datafile
3 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_01.dbf' SIZE 200M autoextend off,
4 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_02.dbf' SIZE 200M autoextend off
5 logging
6 extent management local;
create tablespace shoptb
*
ERROR at line 1:
ORA-01031: insufficient privileges
Comment