--将视图赋予某用户访问权限
DROP USER SUNCTI CASCADE;
CREATE USER SUNCTI IDENTIFIED BY SUNCTI
DEFAULT TABLESPACE "GISAP"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED ON "GISAP";
GRANT CONNECT TO SUNCTI;
ALTER USER GISAP DEFAULT ROLE NONE;
GRANT CREATE SESSION TO GISAP;
GRANT SELECT ON "GISAP"."V_LBS_INFO" TO SUNCTI;
--创建公共同义词
DROP PUBLIC SYNONYM SYN_LBS_INFO;
CREATE PUBLIC SYNONYM SYN_LBS_INFO FOR GISAP.V_LBS_INFO;
--赋予SUNCTI创建专有同义词权限
GRANT CREATE SYNONYM TO SUNCTI;
DROP SYNONYM SYN_LBS_INFO;
CREATE SYNONYM SYN_LBS_INFO FOR GISAP.V_LBS_INFO;
--取消SUNCTI创建专有同义词权限
REVOKE CREATE SYNONYM FROM SUNCTI;
DROP USER SUNCTI CASCADE;
CREATE USER SUNCTI IDENTIFIED BY SUNCTI
DEFAULT TABLESPACE "GISAP"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED ON "GISAP";
GRANT CONNECT TO SUNCTI;
ALTER USER GISAP DEFAULT ROLE NONE;
GRANT CREATE SESSION TO GISAP;
GRANT SELECT ON "GISAP"."V_LBS_INFO" TO SUNCTI;
--创建公共同义词
DROP PUBLIC SYNONYM SYN_LBS_INFO;
CREATE PUBLIC SYNONYM SYN_LBS_INFO FOR GISAP.V_LBS_INFO;
--赋予SUNCTI创建专有同义词权限
GRANT CREATE SYNONYM TO SUNCTI;
DROP SYNONYM SYN_LBS_INFO;
CREATE SYNONYM SYN_LBS_INFO FOR GISAP.V_LBS_INFO;
--取消SUNCTI创建专有同义词权限
REVOKE CREATE SYNONYM FROM SUNCTI;