Why can't create table?
Using system operator account to creat a user and assign some privilege to it,like follows:
SQL> create user a1 identified by a1;
SQL> grant create session to a1;
SQL> grant create table to a1;
Then connect Oracle as this user,and create a table,like follows:
SQL> create table a_1(col1 varchar2(20));
create table a_1(col1 varchar2(20))
ERROR at line 1:
ORA-01950: table space 'SYSTEM' no right
I have assign create table privilege to user a1,why still above error? How to make user a1 can create table? I only want to make user a1 to create table and don't want to let him more other rights.
How to do it?