-- 1. 授权。如:授予 create any synonym 的权限grantcreateany synonym to scott;-- 2. 回收。如:回收 create any synonym 的权限revokecreateany synonym to scott;-- 3. 查询所有可 授予|回收 的权限selectdistinct t.privilege
from dba_sys_privs t
where t.privilege like'%SYNONYM%'orderby t.privilege;