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?

Thanks.

SQL> edit
Wrote file afiedt.buf

  1 create user a1 identified by a1
  2 default tablespace ap_test
  3* QUOTA 10M on ap_test
SQL> /

User created.

SQL> grant create session to a1;

Grant succeeded.

SQL> grant create table to a1;

Grant succeeded.

SQL> create table a_1(col1 varchar2(20));

Table created.

sorry :)

apdev@ORCL10G>connect a1/a1@orcl
Connected.
a1@ORCL10G>create table a_1(col1 varchar2(20));
Table created.