Oracle创建只读账号的详细步骤

转自:https://www.cnblogs.com/yaoyangding/p/15205570.html

在只读账号HTREADER端执行：添加显示各个表信息；在SYSNONYM目录下，tables目录下无显示

create or replace SYNONYM htreader.VIN_LIST for HEPSUSR.VIN_LIST;

create or replace SYNONYM htreader.SUB_SWAP for HEPSUSR.SUB_SWAP;

create or replace SYNONYM htreader.SUB_MESSAGE_INFO for HEPSUSR.SUB_MESSAGE_INFO;

create or replace SYNONYM htreader.IQ_CERT for HEPSUSR.IQ_CERT;

create or replace SYNONYM htreader.IQ_APPEND for HEPSUSR.IQ_APPEND;

create or replace SYNONYM htreader.ENTRY_WORKFLOW for HEPSUSR.ENTRY_WORKFLOW;

create or replace SYNONYM htreader.ENTRY_LIST for HEPSUSR.ENTRY_LIST;

create or replace SYNONYM htreader.ENTRY_HEAD for HEPSUSR.ENTRY_HEAD;

create or replace SYNONYM htreader.ENTRY_GOODS_TAX for HEPSUSR.ENTRY_GOODS_TAX;

create or replace SYNONYM htreader.ENTRY_FEES for HEPSUSR.ENTRY_FEES;

create or replace SYNONYM htreader.ENTRY_DOCU for HEPSUSR.ENTRY_DOCU;

create or replace SYNONYM htreader.ENTRY_DECL_TAX for HEPSUSR.ENTRY_DECL_TAX;

create or replace SYNONYM htreader.ENTRY_CONTAINER for HEPSUSR.ENTRY_CONTAINER;

create or replace SYNONYM htreader.ENTRY_CERT_RELATION for HEPSUSR.ENTRY_CERT_RELATION;

create or replace SYNONYM htreader.ENTRY_CERT for HEPSUSR.ENTRY_CERT;