--将视图赋予某用户访问权限
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;

ITPub博客

怎么样将一个视图赋权给另一个用户访问？