Oracle 授权同义词

2014-11-24 18:44:34 · 作者: · 浏览: 0

GRANT SELECT ON ADT.BO_EMPLOYEE TO ITAWEB;
GRANT INSERT ON ADT.BO_EMPLOYEE TO ITAWEB;
GRANT UPDATE ON ADT.BO_EMPLOYEE TO ITAWEB;
GRANT DELETE ON ADT.BO_EMPLOYEE TO ITAWEB;


ADT:源用户名


BO_EMPLOYEE :授权的表名


ITAWEB:授权的用户名


授权给用与创建同义词:grant CREATE SYNONYM to user ; (不授权,可能会显示:权限不足。)