oracle视图，同义词,创建及更改

一、创建或替换视图

create or replace view PR_IF_SCX as               
select (B.YEARPLANTDATE||B.MMPLANTDATE||B.DAYPLANTDATE) AS PLANDATE, B.SHPLANDATE,B.PRSNTSTATLINE, B.HOLDTP,A.PRODSUFFIX,count(*) as CARCOUNT
from   PR_T_Vhtb1010 A RIGHT JOIN  PR_T_VHTB1040 B
ON A.IDNO=B.IDNO and A.PLANTCODE=B.PLANTCODE and A.PSC=B.PSC
where substr(A.SPEC ,58,1) =' '
GROUP BY  (B.YEARPLANTDATE||B.MMPLANTDATE||B.DAYPLANTDATE) , B.SHPLANDATE,B.PRSNTSTATLINE,A.PRODSUFFIX, B.HOLDTP     
with read only  

二、给用户赋权

grant select on PR_IF_SCX to SCXUSER;

三、创建同义词

create or replace synonym PR_IF_SCX for OUSLC05OPRUSER.PR_IF_SCX;

注：如果替换了视图，必须重新给用户赋权，而且要重新创建覆盖同义词