NAPRAVIO VIEW  ( iz usera INTEGRA )

 

CREATE OR REPLACE VIEW MIL_NALOG_ISPORUKA_VIEW AS

SELECT DeliveryDate,MILWarehouseCode,ShippedQty,LOT,ExpDate,ExportFlag,UpdateFlag

FROM MIL_NALOG_ISPORUKA

 

CREATE OR REPLACE VIEW MIL_PRIJEM_VIEW AS

SELECT ReceiptDate,ReceivedQty,ExportFlag,UpdateFlag

FROM MIL_PRIJEM

--------------------------------------------------------------------------------------------------------------------

create user MILSPED identified by milsped;   

grant select,update on INTEGRA.MIL_NALOG_ISPORUKA to MILSPED

grant select,update on INTEGRA.MIL_PRIJEM to MILSPED;

--------------------------------------------------------------------------------------------------------------------

Napravljeni synonim

CREATE PUBLIC SYNONYM MIL_PRIJEM for INTEGRA.MIL_PRIJEM;

CREATE PUBLIC SYNONYM MIL_NALOG_ISPORUKA for INTEGRA.MIL_NALOG_ISPORUKA;

 

GRANT NAD NOVIM -TABELAMA ( viewima )

grant select,update on INTEGRA.MIL_NALOG_ISPORUKA_VIEW to MILSPED

grant select,update on INTEGRA.MIL_PRIJEM_VIEW to MILSPED;

 

 

Developer 

tools/ compare user objects 

izaberi usera

target session 

 

compare

 

prebacuje kostur na drugu masinu