Oracle error ORA-01950 the tablespace "system" without permission __oracle

Environment: Oracle 11g R2 + sqlplus

Issue: Create user, create table with ORA-01950 error on tablespace ' system ' without permissions

Resolution: This problem, obviously, is the issue of permissions. After the user is created, the permissions are not granted correctly.

Method One:

Open the SQL Plus------------> execute the following command:

Conn System/manager;
Grant resource to Tiger;

Description: Granting permissions is not necessarily tiger, here is an example. It should actually be the new user you created.

Method Two:

Open the SQL Plus------------> execute the following command:

Conn Scott/tiger as SYSDBA;

Note: When a user connects, let this user have SYSDBA permissions, of course, create a table. Will not report this mistake again.

References: http://blog.csdn.net/mainpulate/article/details/7183736