-- select 'grant select on ' || table_name || ' to FDBP5_USER;' from user_tables;
SET FEEDBACK OFF;
SET ECHO OFF;

grant select on FDB_AHFS_ASSOC_GS_MONOGRAPH to FDBP5_USER;   
grant select on FDB_AHFS_ASSOC_MONOGRAPH_CLASS to FDBP5_USER;
grant select on FDB_AHFS_CLASSIFICATION_LINK to FDBP5_USER;  
grant select on FDB_AHFS_MONOGRAPH to FDBP5_USER;            
grant select on FDB_AHFS_SECTION to FDBP5_USER;              
grant select on FDB_AHFS_TITLE to FDBP5_USER;                
grant select on FDB_ALLERGEN_EXT_VOCAB_LINK to FDBP5_USER;   
grant select on FDB_ALLERGENGROUP to FDBP5_USER;             
grant select on FDB_ALLERGENPICKLIST_SEARCH to FDBP5_USER;   
grant select on FDB_ALLERGYCROSSSENSITIVITY to FDBP5_USER;   
grant select on FDB_CLASSIFICATION to FDBP5_USER;            
grant select on FDB_CLASSIFICATION_CLASS_LINK to FDBP5_USER; 
grant select on FDB_CLASSIFICATION_DRUG_LINK to FDBP5_USER;  
grant select on FDB_CLINICAL_LINK to FDBP5_USER;             
grant select on FDB_CLINICAL_LINK_AHFSMONO to FDBP5_USER;    
grant select on FDB_CLINICAL_LINK_DAM to FDBP5_USER;         
grant select on FDB_CLINICAL_LINK_DAM_RELHIT to FDBP5_USER;  
grant select on FDB_CLINICAL_LINK_DDC to FDBP5_USER;         
grant select on FDB_CLINICAL_LINK_IND to FDBP5_USER;         
grant select on FDB_CLINICAL_LINK_SIDE to FDBP5_USER;        
grant select on FDB_CMM_LINK to FDBP5_USER;                  
grant select on FDB_CMM_MESSAGE to FDBP5_USER;               
grant select on FDB_CODEDEFINITION to FDBP5_USER;            
grant select on FDB_CODEDEFINITION_EXPANDED to FDBP5_USER;   
grant select on FDB_CODETYPE to FDBP5_USER;                  
grant select on FDB_DDC to FDBP5_USER;                       
grant select on FDB_DDIM_INACTIVE_LINK to FDBP5_USER;        
grant select on FDB_DDIM_LINK to FDBP5_USER;                 
grant select on FDB_DDIMINTERACTION to FDBP5_USER;           
grant select on FDB_DFIMINTERACTION to FDBP5_USER;           
grant select on FDB_DISCLAIMER to FDBP5_USER;                
grant select on FDB_DISPENSABLE to FDBP5_USER;               
grant select on FDB_DISPENSABLE_CLNCL_QTY to FDBP5_USER;     
grant select on FDB_DISPENSABLE_GEN_LINK to FDBP5_USER;      
grant select on FDB_DISPENSABLE_LABELER to FDBP5_USER;       
grant select on FDB_DISPENSABLE_PACKAGEDDRUG to FDBP5_USER;  
grant select on FDB_DISPENSABLE_SEARCH to FDBP5_USER;        
grant select on FDB_DISPENSABLE_SEARCH_TERM to FDBP5_USER;   
grant select on FDB_DISPENSABLE_VALUE to FDBP5_USER;         
grant select on FDB_DOSE_TYPE to FDBP5_USER;                 
grant select on FDB_DOSING to FDBP5_USER;                    
grant select on FDB_DOSING_EXCLUSION_REASON to FDBP5_USER;   
grant select on FDB_DOSING_MINMAX to FDBP5_USER;             
grant select on FDB_DOSING_MINMAX_PAT_PARAM to FDBP5_USER;   
grant select on FDB_DOSING_PAT_PARAM to FDBP5_USER;          
grant select on FDB_DOSING_RENAL to FDBP5_USER;              
grant select on FDB_DOSING_RENAL_PAT_PARAM to FDBP5_USER;    
grant select on FDB_DOSING_SEVERITY_LEVEL to FDBP5_USER;     
grant select on FDB_DRUG_GEN_DRUGNAME to FDBP5_USER;         
grant select on FDB_DRUG_GEN_NAMED_LINK to FDBP5_USER;       
grant select on FDB_DRUG_INACTIVE_INGRED to FDBP5_USER;      
grant select on FDB_DRUG_INACTIVE_STUDY to FDBP5_USER;       
grant select on FDB_DRUGNAME to FDBP5_USER;                  
grant select on FDB_DRUGNAME_GEN_LINK to FDBP5_USER;         
grant select on FDB_DRUGNAME_SEARCH to FDBP5_USER;           
grant select on FDB_DRUGNAME_VALUE to FDBP5_USER;            
grant select on FDB_DUPLICATETHERAPY to FDBP5_USER;          
grant select on FDB_EXT_ALLERGEN_VOCAB_LINK to FDBP5_USER;   
grant select on FDB_EXT_PRODUCT_CD_DESC to FDBP5_USER;       
grant select on FDB_EXT_PRODUCT_CODE to FDBP5_USER;          
grant select on FDB_EXT_VOCAB to FDBP5_USER;                 
grant select on FDB_EXT_VOCAB_CATEGORY_LINK to FDBP5_USER;   
grant select on FDB_EXT_VOCAB_DATA_VERSION to FDBP5_USER;    
grant select on FDB_EXT_VOCAB_EXT_LINK to FDBP5_USER;        
grant select on FDB_EXT_VOCAB_EXT_LINK_VALUE to FDBP5_USER;  
grant select on FDB_EXT_VOCAB_FDB_LINK to FDBP5_USER;        
grant select on FDB_EXT_VOCAB_FDB_LINK_VALUE to FDBP5_USER;  
grant select on FDB_EXT_VOCAB_REPLACEMENT to FDBP5_USER;     
grant select on FDB_EXT_VOCAB_TYPE_CD to FDBP5_USER;         
grant select on FDB_EXT_VOCAB_VALUE to FDBP5_USER;           
grant select on FDB_FCS_ASSOC_SCHEDULEDEA to FDBP5_USER;     
grant select on FDB_FCS_ASSOC_UNIVFEDSCHED to FDBP5_USER;    
grant select on FDB_FCS_ASSOC_UNIVSTATE to FDBP5_USER;       
grant select on FDB_FCS_ASSOC_UNIVSTATEPDMP to FDBP5_USER;   
grant select on FDB_FCS_DEAMASTER to FDBP5_USER;             
grant select on FDB_FCS_STATEMULTICODE to FDBP5_USER;        
grant select on FDB_FDA_APP_RELATIONSHIP to FDBP5_USER;      
grant select on FDB_FREQUENCY_INTERVAL to FDBP5_USER;        
grant select on FDB_GEN_DISP_INGSTR_TYPE to FDBP5_USER;      
grant select on FDB_GEN_DISPENSABLE to FDBP5_USER;           
grant select on FDB_GEN_DISPENSABLE_ING_STR to FDBP5_USER;   
grant select on FDB_GEN_DISPENSABLE_LINK to FDBP5_USER;      
grant select on FDB_GEN_DISPENSABLE_SEARCH to FDBP5_USER;    
grant select on FDB_GEN_DISPENSABLE_VALUE to FDBP5_USER;     
grant select on FDB_GEN_DRUGNAME to FDBP5_USER;              
grant select on FDB_GEN_DRUGNAME_INGRED to FDBP5_USER;       
grant select on FDB_GEN_DRUGNAME_LINK to FDBP5_USER;         
grant select on FDB_GEN_DRUGNAME_SEARCH to FDBP5_USER;       
grant select on FDB_GEN_DRUGNAME_VALUE to FDBP5_USER;        
grant select on FDB_GEN_ROUTEDDFDRUG to FDBP5_USER;          
grant select on FDB_GEN_ROUTEDDFDRUG_LINK to FDBP5_USER;     
grant select on FDB_GEN_ROUTEDDFDRUG_SEARCH to FDBP5_USER;   
grant select on FDB_GEN_ROUTEDDFDRUG_VALUE to FDBP5_USER;    
grant select on FDB_GEN_ROUTEDDRUG to FDBP5_USER;            
grant select on FDB_GEN_ROUTEDDRUG_LINK to FDBP5_USER;       
grant select on FDB_GEN_ROUTEDDRUG_SEARCH to FDBP5_USER;     
grant select on FDB_GEN_ROUTEDDRUG_VALUE to FDBP5_USER;      
grant select on FDB_HR_ACTION to FDBP5_USER;                 
grant select on FDB_HR_ADDITIONALTEXT to FDBP5_USER;         
grant select on FDB_HR_ASSOC_INFOBYTE_ACTION to FDBP5_USER;  
grant select on FDB_HR_ASSOC_RISK_INFOBYTE to FDBP5_USER;    
grant select on FDB_HR_ASSOC_RISK_MITIGATION to FDBP5_USER;  
grant select on FDB_HR_ASSOC_RISK_MONOGRAPH to FDBP5_USER;   
grant select on FDB_HR_ASSOC_UNIVID to FDBP5_USER;           
grant select on FDB_HR_INFOBYTE to FDBP5_USER;               
grant select on FDB_HR_MONOGRAPH to FDBP5_USER;              
grant select on FDB_HR_MONOGRAPHDETAIL to FDBP5_USER;        
grant select on FDB_HR_REPLACEMENT to FDBP5_USER;            
grant select on FDB_HR_RISK to FDBP5_USER;                   
grant select on FDB_IMPRINT to FDBP5_USER;                   
grant select on FDB_IMPRINT_CLARITY_LIST to FDBP5_USER;      
grant select on FDB_IMPRINT_COATING_LIST to FDBP5_USER;      
grant select on FDB_IMPRINT_COLOR_LIST to FDBP5_USER;        
grant select on FDB_IMPRINT_COLOR_PALETTE to FDBP5_USER;     
grant select on FDB_IMPRINT_COLOR_XREF to FDBP5_USER;        
grant select on FDB_IMPRINT_DOSEFORM_LIST to FDBP5_USER;     
grant select on FDB_IMPRINT_FLAVOR_LIST to FDBP5_USER;       
grant select on FDB_IMPRINT_IMAGE to FDBP5_USER;             
grant select on FDB_IMPRINT_MFR_LIST to FDBP5_USER;          
grant select on FDB_IMPRINT_SCORING_LIST to FDBP5_USER;      
grant select on FDB_IMPRINT_SHAPE_LIST to FDBP5_USER;        
grant select on FDB_IMPRINT_SHAPE_PALETTE to FDBP5_USER;     
grant select on FDB_IMPRINT_TEXT to FDBP5_USER;              
grant select on FDB_IMPRINT_TEXT_XREF to FDBP5_USER;         
grant select on FDB_IND to FDBP5_USER;                       
grant select on FDB_INGRED_ALLERGENGROUP to FDBP5_USER;      
grant select on FDB_INGREDIENT to FDBP5_USER;                
grant select on FDB_LABELER to FDBP5_USER;                   
grant select on FDB_LBLW_LINK to FDBP5_USER;                 
grant select on FDB_LBLW_TEXT to FDBP5_USER;                 
grant select on FDB_LBLW_VENDOR to FDBP5_USER;               
grant select on FDB_MASTER_DOSAGE_FORM to FDBP5_USER;        
grant select on FDB_MASTER_DOSAGE_FORM_GENDF to FDBP5_USER;  
grant select on FDB_MASTER_DOSAGE_FORM_MEDDF to FDBP5_USER;  
grant select on FDB_MASTER_ROUTE to FDBP5_USER;              
grant select on FDB_MASTER_ROUTE_DOSAGE_FORM to FDBP5_USER;  
grant select on FDB_MASTER_ROUTE_SINGLE_ROUTE to FDBP5_USER; 
grant select on FDB_MASTER_UNIT to FDBP5_USER;               
grant select on FDB_MC_INCLUSION_REASON to FDBP5_USER;       
grant select on FDB_MC_MEASURE to FDBP5_USER;                
grant select on FDB_MC_MEASURE_TIMEFRAME to FDBP5_USER;      
grant select on FDB_MC_PRODUCT_ATTR to FDBP5_USER;           
grant select on FDB_MC_PRODUCT_ATTR_DESC to FDBP5_USER;      
grant select on FDB_MC_PRODUCT_ATTR_TYPE to FDBP5_USER;      
grant select on FDB_MC_PRODUCT_ATTR_VALUE to FDBP5_USER;     
grant select on FDB_MC_PRODUCT_DOSE to FDBP5_USER;           
grant select on FDB_MEDCOND to FDBP5_USER;                   
grant select on FDB_MEDCOND_EXT to FDBP5_USER;               
grant select on FDB_MEDCOND_EXT_BEST_FIT to FDBP5_USER;      
grant select on FDB_MEDCOND_EXT_BILLABLE_HIST to FDBP5_USER; 
grant select on FDB_MEDCOND_EXT_EXCLUSION to FDBP5_USER;     
grant select on FDB_MEDCOND_EXT_HIERARCHY to FDBP5_USER;     
grant select on FDB_MEDCOND_EXT_LINK to FDBP5_USER;          
grant select on FDB_MEDCOND_EXT_VALUE to FDBP5_USER;         
grant select on FDB_MEDCOND_HIERARCHY to FDBP5_USER;         
grant select on FDB_MEDCOND_RELATED to FDBP5_USER;           
grant select on FDB_MEDCOND_REPLACEMENT to FDBP5_USER;       
grant select on FDB_MEDCOND_SYNONYM to FDBP5_USER;           
grant select on FDB_MEDCOND_VALUE to FDBP5_USER;             
grant select on FDB_MONOGRAPH_DDIM to FDBP5_USER;            
grant select on FDB_MONOGRAPH_DFIM to FDBP5_USER;            
grant select on FDB_MONOGRAPH_DOSING to FDBP5_USER;          
grant select on FDB_MONOGRAPH_PEM to FDBP5_USER;             
grant select on FDB_PACKAGEDDRUG to FDBP5_USER;              
grant select on FDB_PACKAGEDDRUG_CLNCL_QTY to FDBP5_USER;    
grant select on FDB_PACKAGEDDRUG_DISP_HIST to FDBP5_USER;    
grant select on FDB_PACKAGEDDRUG_DISP_HIST_RSN to FDBP5_USER;
grant select on FDB_PACKAGEDDRUG_PRICE to FDBP5_USER;        
grant select on FDB_PACKAGEDDRUG_SEARCH to FDBP5_USER;       
grant select on FDB_PACKAGEDDRUG_VALUE to FDBP5_USER;        
grant select on FDB_PEDIATRIC_WEIGHT to FDBP5_USER;          
grant select on FDB_PRECGERI to FDBP5_USER;                  
grant select on FDB_PRECLACT to FDBP5_USER;                  
grant select on FDB_PRECPEDI to FDBP5_USER;                  
grant select on FDB_PRECPREG to FDBP5_USER;                  
grant select on FDB_PRECPREG_MONO to FDBP5_USER;             
grant select on FDB_PRECPREG_REFERENCE to FDBP5_USER;        
grant select on FDB_PRODUCT to FDBP5_USER;                   
grant select on FDB_PRODUCT_PRICE to FDBP5_USER;             
grant select on FDB_PRODUCT_PRICE_ATTR_DESC to FDBP5_USER;   
grant select on FDB_PRODUCT_PRICE_ATTR_TYPE to FDBP5_USER;   
grant select on FDB_PRODUCT_PRICE_ATTRIBUTE to FDBP5_USER;   
grant select on FDB_PRODUCT_PRICE_TYPE to FDBP5_USER;        
grant select on FDB_PROPERTY_NAME to FDBP5_USER;             
grant select on FDB_PROPERTY_VALUE to FDBP5_USER;            
grant select on FDB_REFERENCE to FDBP5_USER;                 
grant select on FDB_RELATED_ROUTE to FDBP5_USER;             
grant select on FDB_REPLACEMENT to FDBP5_USER;               
grant select on FDB_ROUTEDDFDRUG to FDBP5_USER;              
grant select on FDB_ROUTEDDFDRUG_GEN_LINK to FDBP5_USER;     
grant select on FDB_ROUTEDDFDRUG_SEARCH to FDBP5_USER;       
grant select on FDB_ROUTEDDFDRUG_VALUE to FDBP5_USER;        
grant select on FDB_ROUTEDDRUG to FDBP5_USER;                
grant select on FDB_ROUTEDDRUG_GEN_LINK to FDBP5_USER;       
grant select on FDB_ROUTEDDRUG_SEARCH to FDBP5_USER;         
grant select on FDB_ROUTEDDRUG_VALUE to FDBP5_USER;          
grant select on FDB_RXNORM_CONCEPT to FDBP5_USER;            
grant select on FDB_RXNORM_CS_EXCEPTION to FDBP5_USER;       
grant select on FDB_RXNORM_CS_LINK to FDBP5_USER;            
grant select on FDB_RXNORM_TERM to FDBP5_USER;               
grant select on FDB_RXNORM_TERM_DESC to FDBP5_USER;          
grant select on FDB_SCT_LINK to FDBP5_USER;                  
grant select on FDB_SCT_VALUE_SET to FDBP5_USER;             
grant select on FDB_SCT_VALUE_SET_DESC to FDBP5_USER;        
grant select on FDB_SIDE to FDBP5_USER;                      
grant select on FDB_UOM_CONVERSION to FDBP5_USER;            
grant select on FDB_UOM_TYPE_DESCRIPTION to FDBP5_USER;      
grant select on FDB_USHIK to FDBP5_USER;                     
grant select on FDB_VERSION to FDBP5_USER;                   
grant select on FDB_CUSTOM_ALLERGENPICKLSTSRCH to FDBP5_USER;
grant select on FDB_CUSTOM_ATTRIBUTE_NAME to FDBP5_USER;     
grant select on FDB_CUSTOM_ATTRIBUTE_VALUE to FDBP5_USER;    
grant select on FDB_CUSTOM_CLINICAL_DRUG to FDBP5_USER;      
grant select on FDB_CUSTOM_CLINICAL_EXCLUSION to FDBP5_USER; 
grant select on FDB_CUSTOM_DDIM_DRUGLINKCAT to FDBP5_USER;   
grant select on FDB_CUSTOM_DDIM_SEVERITY to FDBP5_USER;      
grant select on FDB_CUSTOM_DOSING to FDBP5_USER;             
grant select on FDB_CUSTOM_DOSING_MINMAX to FDBP5_USER;      
grant select on FDB_CUSTOM_DOSING_PAT_PARAM to FDBP5_USER;   
grant select on FDB_CUSTOM_DOSING_RENAL to FDBP5_USER;       
grant select on FDB_CUSTOM_DOSING_RENAL_PAT_PM to FDBP5_USER;
grant select on FDB_CUSTOM_DPT_ALLOWANCE to FDBP5_USER;      
grant select on FDB_CUSTOM_FREQUENCY_INTERVAL to FDBP5_USER; 
grant select on FDB_CUSTOM_INDICATION to FDBP5_USER;         
grant select on FDB_CUSTOM_MINMAX_PAT_PARAM to FDBP5_USER;   
grant select on FDB_CUSTOM_MONOGRAPH to FDBP5_USER;          
grant select on FDB_CUSTOM_MONOGRAPH_LINK to FDBP5_USER;     

exit;