oracle创建表空间和用户，并且设置权限

---创建表空间

CREATE TABLESPACE TS_TGCBS
LOGGING 
DATAFILE 'D:\ORACLEData\TS_TGCBS.DBF' SIZE 20000M REUSE
AUTOEXTEND 
ON NEXT 100M MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT 
SPACE MANAGEMENT AUTO;

---以sys用户执行下列sql语句，创建风控系统用户

CREATE USER hsrisk3  PROFILE DEFAULT

IDENTIFIED BY hsrisk3 DEFAULT TABLESPACETS_RISK3

TEMPORARY TABLESPACE TEMP

ACCOUNT UNLOCK;

---以sys用户执行下列sql语句，为风控系统用户赋数据库权限

GRANT CONNECT TO hsrisk3;

GRANT RESOURCE TO hsrisk3;

GRANT CREATE VIEW TO hsrisk3;

GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO hsrisk3;

GRANT DELETE ANY TABLE TO hsrisk3;

GRANT DROP ANY TABLE TO hsrisk3;

GRANT SELECT ANY TABLE TO hsrisk3;

GRANT UPDATE ANY TABLE TO hsrisk3;

GRANT INSERT ANY TABLE TO hsrisk3;

GRANT ANALYZE ANY TO hsrisk3;

grantcreate database link to hsrisk3;

grantcreate synonym to hsrisk3;

GRANT ANALYZE ANY TO hsrisk3;