同义词synonym创建授权

GRANT CREATE ANY SYNONYM TO "IAMPHK"
GRANT CREATE PUBLIC SYNONYM TO "IAMPHK"
GRANT CREATE SYNONYM TO "IAMPHK"

GRANT DROP ANY SYNONYM TO "IAMPHK"
GRANT DROP PUBLIC SYNONYM TO "IAMPHK"

 

create or replace synonym RP_custinfo
  for IAMP_POL.RP_custinfo;
grant select, insert, update, delete, references, alter, index on IAMP_POL.RP_CUSTINFO to IAMPHK;
grant all on IAMP_POL.RP_custinfo to IAMPHK;