GRANT SELECT, INSERT, UPDATE, DELETE ON 
prd_adjustment_calc,
prd_adjustment_dependent_detail,
prm_adjustment_defined,
prd_adjustment_report,
prd_bonus_parameter_calc,
prd_employee_revision,
prd_execute_start_history,
prd_health_revision,
prd_payroll_bonus_calc,
prd_payroll_bonus_detail,
prd_payroll_bonus_transfer,
prd_payroll_change_calc,
prd_payroll_parameter_calc,
prd_resident_tax_transfer,
prm_adjustment_income_deduction,
prm_adjustment_income_difference,
prm_adjustment_insurance_deduction,
prm_adjustment_request,
prm_adjustment_tax,
prm_bank,
prm_bonus_k_tax,
prm_bonus_o_tax,
prm_company,
prm_company_payroll,
prm_detail,
prm_detail_item,
prm_employee_pension_grade,
prm_exchange_bank,
prm_health_insurance_grade,
prm_health_office,
prm_labor_management,
prm_labor_office,
prm_message,
prm_name_management,
prm_naming,
prm_office,
prm_payroll_book,
prm_payroll_human,
prm_payroll_income_deduction,
prm_payroll_k_income_deduction,
prm_payroll_o_tax,
prm_payroll_scale,
prm_payroll_section,
prm_payroll_system,
prm_payroll_system_item,
prm_payroll_tax,
prm_payroll_type_rate,
prm_personal_address,
prm_personal_dependent,
prm_personal_dependent_detail,
prm_personal_fixed_deduction,
prm_personal_fixed_payment,
prm_personal_labor,
prm_personal_payroll,
prm_personal_resident,
prm_personal_social,
prm_personal_transfer,
prm_personal_unit,
prm_resident_tax,
prm_system_parameter,
prm_system_parameter_item,
prm_system_parameter_type
 TO usermosp;

GRANT USAGE, SELECT, UPDATE ON 
prd_adjustment_calc_id_seq,
prd_adjustment_dependent_detail_id_seq,
prm_adjustment_defined_id_seq,
prd_adjustment_report_id_seq,
prd_bonus_parameter_calc_id_seq,
prd_employee_revision_id_seq,
prd_execute_start_history_id_seq,
prd_health_revision_id_seq,
prd_payroll_bonus_calc_id_seq,
prd_payroll_bonus_detail_id_seq,
prd_payroll_bonus_transfer_id_seq,
prd_payroll_change_calc_id_seq,
prd_payroll_parameter_calc_id_seq,
prd_resident_tax_transfer_id_seq,
prm_adjustment_income_deduction_id_seq,
prm_adjustment_income_difference_id_seq,
prm_adjustment_insurance_deduction_id_seq,
prm_adjustment_request_id_seq,
prm_adjustment_tax_id_seq,
prm_bank_id_seq,
prm_bonus_k_tax_id_seq,
prm_bonus_o_tax_id_seq,
prm_company_id_seq,
prm_company_payroll_id_seq,
prm_detail_id_seq,
prm_detail_item_id_seq,
prm_employee_pension_grade_id_seq,
prm_exchange_bank_id_seq,
prm_health_insurance_grade_id_seq,
prm_health_office_id_seq,
prm_labor_management_id_seq,
prm_labor_office_id_seq,
prm_message_id_seq,
prm_name_management_id_seq,
prm_naming_id_seq,
prm_office_id_seq,
prm_payroll_book_id_seq,
prm_payroll_human_id_seq,
prm_payroll_income_deduction_id_seq,
prm_payroll_k_income_deduction_id_seq,
prm_payroll_o_tax_id_seq,
prm_payroll_scale_id_seq,
prm_payroll_section_id_seq,
prm_payroll_system_id_seq,
prm_payroll_system_item_id_seq,
prm_payroll_tax_id_seq,
prm_payroll_type_rate_id_seq,
prm_personal_address_id_seq,
prm_personal_dependent_id_seq,
prm_personal_dependent_detail_id_seq,
prm_personal_fixed_deduction_id_seq,
prm_personal_fixed_payment_id_seq,
prm_personal_labor_id_seq,
prm_personal_payroll_id_seq,
prm_personal_resident_id_seq,
prm_personal_social_id_seq,
prm_personal_transfer_id_seq,
prm_personal_unit_id_seq,
prm_resident_tax_id_seq,
prm_system_parameter_id_seq,
prm_system_parameter_item_id_seq,
prm_system_parameter_type_id_seq
 TO usermosp;
