ORACLE添加新用户并配置权限 添加其他用户的表权限

select tablespace_name,file_id,bytes/1024/1024,file_name 
　from dba_data_files order by file_id;

--创建表空间
CREATE TABLESPACE KSKFQGHCG
nologging
DATAFILE ‘D:\TABLESPACE\KSKFQGHCG.DBF‘
SIZE 64M
AUTOEXTEND ON;
commit;
--创建KSKFQGHCG用户
CREATE USER KSKFQGHCG
IDENTIFIED BY KSKFQGHCG
DEFAULT TABLESPACE KSKFQGHCG TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
commit;
--授于KSKFQGHCG用户相应权限
GRANT CREATE ANY SEQUENCE TO KSKFQGHCG;
GRANT CREATE ANY TABLE TO KSKFQGHCG;
GRANT ENQUEUE ANY QUEUE TO KSKFQGHCG;
GRANT UNLIMITED TABLESPACE TO KSKFQGHCG;
GRANT CONNECT TO KSKFQGHCG;
GRANT DBA TO KSKFQGHCG;
GRANT RECOVERY_CATALOG_OWNER TO KSKFQGHCG;
GRANT RESOURCE TO KSKFQGHCG;
commit;

GRANT CREATE ANY TABLE TO KSKFQGHCG;
GRANT RESOURCE TO KSKFQGHCG;

grant select any table to KSKFQGHCG;