创建用户后，用sqlplus为用户分配权限（其实是分配角色）

用sys 创建的用户locuser 分配给locuser的tablespaces:(Default是users,Temporary是Temp),
但是创建的表tbl却出现在the tablespace of system,
回头去检查操作步骤发现是用sys连接后没有退出，直接创建了表tbl.



create user test identified by test default tablespace users quota 10m on users;
grant connect,resource to test;
其实是分配角色:
ALTER DATABASE
    DATAFILE 'G:\ORACLE\ORADATA\OCP9\INDX01.DBF' AUTOEXTEND ON
ROLE CONNECT :
ALTER SESSION
CREATE CLUSTER
CREATE DATABASE LINK
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
相关对象权限 你自己的对象，别人授予你的对象等
ROLE resource :
CREATE CLUSTER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE PROCEDURE
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
+++++++++++++++++++++++++++++++++++++++++++


++++++++++++++++++

+++++++++++++++

++++++++++++++++++++++
创建了user locuser后在schema节中找不到locuser，刷新一下，就显示出来了
++++++++++++++++++++++