Oracle 授权同义词
Oracle 授权同义词
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 ; (不授权,可能会显示:权限不足。)
评论暂时关闭