web_usr.sql

GRANT USAGE ON SCHEMA annotation TO web_usr;
GRANT USAGE ON SCHEMA biosource TO web_usr;
GRANT USAGE ON SCHEMA gem TO web_usr;
GRANT USAGE ON SCHEMA genomic TO web_usr;
GRANT USAGE ON SCHEMA insitu TO web_usr;
GRANT USAGE ON SCHEMA metadata TO web_usr;
GRANT USAGE ON SCHEMA pheno_population TO web_usr;
GRANT USAGE ON SCHEMA phenome TO web_usr;
GRANT USAGE ON SCHEMA physical TO web_usr;
GRANT USAGE ON SCHEMA public TO web_usr;
GRANT USAGE ON SCHEMA sgn TO web_usr;
GRANT USAGE ON SCHEMA sgn_people TO web_usr;
GRANT USAGE ON SCHEMA sgn_submit TO web_usr;
GRANT USAGE ON SCHEMA tomato_gff TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.feature TO web_usr;
GRANT SELECT,DELETE ON TABLE public.featureloc TO web_usr;
GRANT SELECT,INSERT,DELETE ON TABLE public.cvterm TO web_usr;
GRANT ALL ON TABLE public.db TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.dbxref TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_cvterm TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.feature_dbxref TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_synonym TO web_usr;
GRANT SELECT,DELETE ON TABLE public.featureprop TO web_usr;
GRANT ALL ON TABLE public.pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.synonym TO web_usr;
GRANT SELECT,DELETE ON TABLE public.gffatts TO web_usr;
GRANT SELECT ON TABLE annotation.annotation TO web_usr;
GRANT SELECT ON TABLE annotation.comment TO web_usr;
GRANT SELECT ON TABLE annotation.comp_analysis TO web_usr;
GRANT SELECT ON TABLE annotation.dblist TO web_usr;
GRANT SELECT ON TABLE annotation.dbxref TO web_usr;
GRANT SELECT ON TABLE annotation.feature_set TO web_usr;
GRANT SELECT ON TABLE annotation.feature_span TO web_usr;
GRANT SELECT ON TABLE annotation.organism TO web_usr;
GRANT SELECT ON TABLE annotation.output TO web_usr;
GRANT SELECT ON TABLE annotation.person TO web_usr;
GRANT SELECT ON TABLE annotation.program TO web_usr;
GRANT SELECT ON TABLE annotation.property TO web_usr;
GRANT SELECT ON TABLE annotation.result_set TO web_usr;
GRANT SELECT ON TABLE annotation.result_span TO web_usr;
GRANT SELECT ON TABLE annotation.seq TO web_usr;
GRANT SELECT ON TABLE annotation.seq_error TO web_usr;
GRANT SELECT ON TABLE annotation.seq_relationship TO web_usr;
GRANT SELECT ON TABLE annotation.synonym TO web_usr;
GRANT SELECT ON TABLE biosource.bs_protocol TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_protocol_protocol_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_protocol_pub TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_protocol_pub_protocol_pub_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_protocol_step TO web_usr;
GRANT SELECT ON TABLE biosource.bs_protocol_step_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_protocol_step_dbxref_protocol_step_dbxref_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_protocol_step_protocol_step_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_cvterm TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_cvterm_sample_cvterm_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_dbxref_sample_dbxref_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_element TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_element_cvterm TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_element_cvterm_sample_element_cvterm_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_element_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_element_dbxref_sample_element_dbxref_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_element_file TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_element_file_sample_element_file_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_element_relation TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_element_relation_sample_element_relation_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_element_sample_element_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_file TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_file_sample_file_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_pub TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_pub_sample_pub_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_sample_relationship TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_relationship_sample_relationship_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_sample_sample_id_seq TO web_usr;
GRANT SELECT ON TABLE biosource.bs_tool TO web_usr;
GRANT SELECT ON TABLE biosource.bs_tool_pub TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_tool_pub_tool_pub_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE biosource.bs_tool_tool_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_cluster_analysis TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_cluster_analysis_cluster_analysis_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_cluster_member TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_cluster_member_cluster_member_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_cluster_profile TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_cluster_profile_cluster_profile_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_correlation_analysis TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_correlation_analysis_correlation_analysis_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_correlation_member TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_correlation_member_correlation_member_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_data_analysis_process TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_data_analysis_process_data_analysis_process_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_diff_expression TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_diff_expression_diff_expression_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_experiment TO web_usr;
GRANT SELECT ON TABLE gem.ge_experiment_analysis_group TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experiment_analysis_group_experiment_analysis_group_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_experiment_analysis_member TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experiment_analysis_member_experiment_analysis_member_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_experiment_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experiment_dbxref_experiment_dbxref_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experiment_experiment_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_experimental_design TO web_usr;
GRANT SELECT ON TABLE gem.ge_experimental_design_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experimental_design_dbxref_experimental_design_dbxref_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experimental_design_experimental_design_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_experimental_design_pub TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_experimental_design_pub_experimental_design_pub_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_expression_by_experiment TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_expression_by_experiment_expression_by_experiment_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_fluorescanning TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_fluorescanning_fluorescanning_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_hybridization TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_hybridization_hybridization_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_platform TO web_usr;
GRANT SELECT ON TABLE gem.ge_platform_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_platform_dbxref_platform_dbxref_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_platform_design TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_platform_design_platform_design_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_platform_platform_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_platform_pub TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_platform_pub_platform_pub_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_probe TO web_usr;
GRANT SELECT ON TABLE gem.ge_probe_expression TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_probe_expression_probe_expression_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_probe_probe_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_probe_spot TO web_usr;
GRANT SELECT ON TABLE gem.ge_probe_spot_coordinate TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_probe_spot_coordinate_probe_spot_coordinate_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_probe_spot_probe_spot_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_profile_element TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_profile_element_profile_element_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_target TO web_usr;
GRANT SELECT ON TABLE gem.ge_target_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_target_dbxref_target_dbxref_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_target_element TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_target_element_target_element_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_target_target_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_technology_type TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_technology_type_technology_type_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_template TO web_usr;
GRANT SELECT ON TABLE gem.ge_template_dbiref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_template_dbiref_template_dbiref_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_template_dbxref TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_template_dbxref_template_dbxref_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_template_diff_expression TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_template_diff_expression_template_diff_expression_id_seq TO web_usr;
GRANT SELECT ON TABLE gem.ge_template_expression TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_template_expression_template_expression_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE gem.ge_template_template_id_seq TO web_usr;
GRANT SELECT ON TABLE genomic.blast_defline TO web_usr;
GRANT SELECT ON TABLE genomic.blast_hit TO web_usr;
GRANT SELECT ON TABLE genomic.blast_query TO web_usr;
GRANT SELECT ON TABLE genomic.chromat TO web_usr;
GRANT SELECT ON TABLE genomic.clone TO web_usr;
GRANT SELECT ON TABLE genomic.clone_feature TO PUBLIC;
GRANT SELECT ON TABLE genomic.clone_feature TO web_usr;
GRANT SELECT ON TABLE genomic.clone_type TO web_usr;
GRANT SELECT ON TABLE genomic.genbank_submission TO web_usr;
GRANT SELECT ON TABLE genomic.gss TO web_usr;
GRANT SELECT ON TABLE genomic.gss_submitted_to_genbank TO web_usr;
GRANT SELECT ON TABLE genomic.library TO web_usr;
GRANT SELECT ON TABLE genomic.library_annotation_db TO web_usr;
GRANT SELECT ON TABLE genomic.library_shortname_abbreviation TO PUBLIC;
GRANT SELECT ON TABLE genomic.qc_report TO web_usr;
GRANT SELECT ON TABLE genomic.query_source_type TO web_usr;
GRANT SELECT ON TABLE genomic.read_class TO web_usr;
GRANT SELECT ON TABLE genomic.sequencing_primer TO PUBLIC;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.ex_tag TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.experiment TO web_usr;
GRANT ALL ON SEQUENCE insitu.experiment_experiment_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE insitu.experiment_image TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE insitu.experiment_image_experiment_image_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.experiment_tag TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE insitu.experiment_tag_experiment_tag_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.image_tag TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.is_organism TO web_usr;
GRANT ALL ON SEQUENCE insitu.is_organism_is_organism_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.probe TO web_usr;
GRANT ALL ON SEQUENCE insitu.probe_probe_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.tag TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE insitu.tag_implication TO web_usr;
GRANT ALL ON SEQUENCE insitu.tag_tag_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.attribution TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.attribution_attribution_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE metadata.attribution_to TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.attribution_to_attribution_to_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE metadata.comments TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.comments_comment_id_seq TO web_usr;
GRANT SELECT ON TABLE metadata.md_dbipath TO web_usr;
GRANT SELECT ON SEQUENCE metadata.md_dbipath_dbipath_id_seq TO web_usr;
GRANT SELECT ON TABLE metadata.md_dbiref TO web_usr;
GRANT SELECT ON SEQUENCE metadata.md_dbiref_dbiref_id_seq TO web_usr;
GRANT SELECT ON TABLE metadata.md_dbversion TO web_usr;
GRANT SELECT ON SEQUENCE metadata.md_dbversion_dbversion_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.md_files TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE metadata.md_files_file_id_seq TO web_usr;
GRANT SELECT ON TABLE metadata.md_groupmembers TO web_usr;
GRANT SELECT ON SEQUENCE metadata.md_groupmembers_groupmember_id_seq TO web_usr;
GRANT SELECT ON TABLE metadata.md_groups TO web_usr;
GRANT SELECT ON SEQUENCE metadata.md_groups_group_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.md_image TO web_usr;
GRANT SELECT ON TABLE metadata.md_image_cvterm TO web_usr;
GRANT USAGE ON SEQUENCE metadata.md_image_cvterm_md_image_cvterm_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.md_image_image_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE metadata.md_image_organism TO web_usr;
GRANT USAGE ON SEQUENCE metadata.md_image_organism_md_image_organism_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.md_json TO web_usr;
GRANT USAGE ON SEQUENCE metadata.md_json_json_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.md_metadata TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE metadata.md_metadata_metadata_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE metadata.md_tag TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metadata.md_tag_image TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.md_tag_image_tag_image_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.md_tag_tag_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE metadata.roles TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE metadata.roles_role_id_seq TO web_usr;
GRANT SELECT ON TABLE pheno_population.data_points TO web_usr;
GRANT SELECT ON TABLE pheno_population.genotypes TO web_usr;
GRANT SELECT ON TABLE pheno_population.images TO web_usr;
GRANT SELECT ON TABLE pheno_population.locations TO web_usr;
GRANT SELECT ON TABLE pheno_population.organs TO web_usr;
GRANT SELECT ON TABLE pheno_population.plants TO web_usr;
GRANT SELECT ON TABLE pheno_population.populations TO web_usr;
GRANT SELECT ON TABLE pheno_population.properties TO web_usr;
GRANT SELECT ON TABLE pheno_population.samples TO web_usr;
GRANT SELECT ON TABLE pheno_population.sources TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.allele TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.allele_alias TO web_usr;
GRANT UPDATE ON SEQUENCE phenome.allele_alias_allele_alias_id_seq TO web_usr;
GRANT ALL ON SEQUENCE phenome.allele_allele_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.allele_dbxref TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.allele_dbxref_allele_dbxref_id_seq TO web_usr;
GRANT SELECT,INSERT ON TABLE phenome.allele_history TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.allele_history_allele_history_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.cross_type TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.cross_type_cross_type_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.cvterm_pub_ranking TO web_usr;
GRANT SELECT ON TABLE phenome.dbxref_type TO web_usr;
GRANT ALL ON SEQUENCE phenome.dbxref_type_dbxref_type_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.phenome_genotype TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.genotype_experiment TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.genotype_experiment_genotype_experiment_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.genotype_genotype_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.genotype_region TO PUBLIC;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.genotype_region TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.genotype_region_genotype_region_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.germplasm TO web_usr;
GRANT ALL ON SEQUENCE phenome.germplasm_germplasm_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_allele TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_allele_individual_allele_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_dbxref TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_dbxref_evidence TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_dbxref_evidence_history TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_dbxref_evidence_hi_individual_dbxref_evidence_hi_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_dbxref_evidence_individual_dbxref_evidence_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_dbxref_individual_dbxref_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_history TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_history_individual_history_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.individual_image TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.individual_image_individual_image_id_seq TO web_usr;
GRANT ALL ON SEQUENCE phenome.individual_individual_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.individual_locus TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.is_public TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.is_public_is_public_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus2locus TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus2locus_locus2locus_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locus_alias TO web_usr;
GRANT ALL ON SEQUENCE phenome.locus_alias_locus_alias_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus_dbxref TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus_dbxref_evidence TO web_usr;
GRANT SELECT,INSERT ON TABLE phenome.locus_dbxref_evidence_history TO web_usr;
GRANT ALL ON SEQUENCE phenome.locus_dbxref_evidence_history_locus_dbxref_evidence_history_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_dbxref_evidence_locus_dbxref_evidence_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_dbxref_locus_dbxref_id_seq TO web_usr;
GRANT SELECT,INSERT ON TABLE phenome.locus_history TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_history_locus_history_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus_image TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_image_locus_image_id_seq TO web_usr;
GRANT ALL ON SEQUENCE phenome.locus_locus_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.locus_marker TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus_owner TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_owner_locus_owner_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locus_pub_ranking TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locus_pub_ranking_validate TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.locus_registry TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_registry_locus_registry_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locus_unigene TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.locus_unigene_locus_unigene_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locusgroup TO web_usr;
GRANT ALL ON SEQUENCE phenome.locusgroup_locusgroup_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.locusgroup_member TO web_usr;
GRANT ALL ON SEQUENCE phenome.locusgroup_member_locusgroup_member_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.nd_experiment_md_files TO web_usr;
GRANT USAGE ON SEQUENCE phenome.nd_experiment_md_files_nd_experiment_md_files_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE ON TABLE phenome.nd_experiment_md_images TO web_usr;
GRANT USAGE ON SEQUENCE phenome.nd_experiment_md_images_nd_experiment_md_images_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE phenome.nd_experiment_md_json TO web_usr;
GRANT USAGE ON SEQUENCE phenome.nd_experiment_md_json_nd_experiment_md_json_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.phenome_genotype TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.phenotype_user_trait TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.phenotype_user_trait_phenotype_user_trait_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.polymorphic_fragment TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.polymorphic_fragment_polymorphic_fragment_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.population TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.population_dbxref TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.population_dbxref_population_dbxref_id_seq TO web_usr;
GRANT ALL ON SEQUENCE phenome.population_population_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE ON TABLE phenome.project_md_image TO web_usr;
GRANT USAGE ON SEQUENCE phenome.project_md_image_project_md_image_id_seq TO web_usr;
GRANT ALL ON TABLE phenome.project_owner TO web_usr;
GRANT USAGE ON SEQUENCE phenome.project_owner_project_owner_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.pub_curator TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.pub_curator_pub_curator_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.registry TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.registry_registry_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.stock_allele TO web_usr;
GRANT USAGE ON SEQUENCE phenome.stock_allele_stock_allele_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.stock_image TO web_usr;
GRANT USAGE ON SEQUENCE phenome.stock_image_stock_image_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.stock_owner TO web_usr;
GRANT USAGE ON SEQUENCE phenome.stock_owner_stock_owner_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.tomato_il_bin TO PUBLIC;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.tomato_il_bin TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.tomato_il_bin_il_bin_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.tomato_term TO web_usr;
GRANT SELECT ON TABLE phenome.tomato_term2term TO web_usr;
GRANT ALL ON SEQUENCE phenome.tomato_term2term_tomato_term2term_id_seq TO web_usr;
GRANT ALL ON SEQUENCE phenome.tomato_term_tomato_term_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.unit TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.unit_unit_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.user_trait TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE phenome.user_trait_unit TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.user_trait_unit_user_trait_unit_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE phenome.user_trait_user_trait_id_seq TO web_usr;
GRANT SELECT ON TABLE phenome.variant TO web_usr;
GRANT ALL ON SEQUENCE phenome.variant_variant_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.ba_plausibility TO web_usr;
GRANT ALL ON SEQUENCE physical.ba_plausibility_bap_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.bac_associations TO web_usr;
GRANT ALL ON SEQUENCE physical.bac_associations_bac_assoc_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.bac_consensus_sequences TO web_usr;
GRANT ALL ON SEQUENCE physical.bac_consensus_sequences_consensus_seq_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.bac_contigs TO web_usr;
GRANT ALL ON SEQUENCE physical.bac_contigs_bac_contig_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.bac_end_sequences TO web_usr;
GRANT ALL ON SEQUENCE physical.bac_end_sequences_end_seq_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.bac_marker_matches TO web_usr;
GRANT SELECT ON TABLE physical.bacs TO web_usr;
GRANT ALL ON SEQUENCE physical.bacs_bac_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.computational_associations TO web_usr;
GRANT SELECT ON TABLE physical.contig_sizes TO web_usr;
GRANT ALL ON SEQUENCE physical.contig_sizes_contig_size_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.deprecated_probes TO web_usr;
GRANT ALL ON SEQUENCE physical.deprecated_probes_dp_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.fpc_data TO web_usr;
GRANT ALL ON SEQUENCE physical.fpc_data_fpc_datum_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.fpc_version TO web_usr;
GRANT ALL ON SEQUENCE physical.fpc_version_fpc_version_seq TO web_usr;
GRANT SELECT ON TABLE physical.manual_associations TO web_usr;
GRANT SELECT ON TABLE physical.oa_plausibility TO web_usr;
GRANT ALL ON SEQUENCE physical.oa_plausibility_oap_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.overgo_associations TO web_usr;
GRANT ALL ON SEQUENCE physical.overgo_associations_overgo_assoc_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.overgo_plates TO web_usr;
GRANT ALL ON SEQUENCE physical.overgo_plates_plate_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.overgo_results TO web_usr;
GRANT ALL ON SEQUENCE physical.overgo_results_result_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.overgo_version TO web_usr;
GRANT ALL ON SEQUENCE physical.overgo_version_overgo_version_seq TO web_usr;
GRANT SELECT ON TABLE physical.plausible_bacs_in_all_contigs TO web_usr;
GRANT SELECT ON TABLE physical.probe_markers TO web_usr;
GRANT ALL ON SEQUENCE physical.probe_markers_overgo_probe_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.species TO web_usr;
GRANT ALL ON SEQUENCE physical.species_species_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.tentative_association_conflict_groups TO web_usr;
GRANT ALL ON SEQUENCE physical.tentative_association_conflict_groups_tacg_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.tentative_overgo_associations TO web_usr;
GRANT ALL ON SEQUENCE physical.tentative_overgo_associations_tentative_assoc_id_seq TO web_usr;
GRANT SELECT ON TABLE physical.users TO web_usr;
GRANT ALL ON SEQUENCE physical.users_user_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_phenotype TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_project TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_stock TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.phenotype TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.project TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.project_relationship TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.projectprop TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock_relationship TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.genotype TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_genotype TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_protocol TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_protocol TO web_usr;
GRANT ALL ON TABLE public.cvterm_relationship TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.cv TO web_usr;
GRANT SELECT,DELETE ON TABLE public.analysis TO web_usr;
GRANT SELECT,DELETE ON TABLE public.analysisfeature TO web_usr;
GRANT SELECT,DELETE ON TABLE public.analysisprop TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_annotation TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_domain TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_evidef TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_family TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_gfp_ms TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_go_term TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_interactome_all TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_interactome_unique TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_intron TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_map TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_myristoylation TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_pmidlink TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_prefix_info TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_properties TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_scop TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_sequence TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_signalp TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_targetp TO web_usr;
GRANT SELECT,DELETE ON TABLE public.ara_users TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.blastwatch_queries TO web_usr;
GRANT ALL ON SEQUENCE public.blastwatch_queries_blastwatch_queries_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.blastwatch_results TO web_usr;
GRANT ALL ON SEQUENCE public.blastwatch_results_blastwatch_results_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.bug TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.bug_bug_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.contact TO web_usr;
GRANT SELECT ON SEQUENCE public.contact_contact_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.contact_relationship TO web_usr;
GRANT SELECT ON SEQUENCE public.contact_relationship_contact_relationship_id_seq TO web_usr;
GRANT USAGE ON SEQUENCE public.cv_cv_id_seq TO web_usr;
GRANT ALL ON TABLE public.cvprop TO web_usr;
GRANT USAGE,UPDATE ON SEQUENCE public.cvterm_cvterm_id_seq TO web_usr;
GRANT ALL ON TABLE public.cvterm_dbxref TO web_usr;
GRANT ALL ON SEQUENCE public.cvterm_dbxref_cvterm_dbxref_id_seq TO web_usr;
GRANT ALL ON SEQUENCE public.cvterm_relationship_cvterm_relationship_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.cvtermpath TO web_usr;
GRANT SELECT,DELETE ON TABLE public.cvtermprop TO web_usr;
GRANT ALL ON TABLE public.cvtermsynonym TO web_usr;
GRANT ALL ON SEQUENCE public.cvtermsynonym_cvtermsynonym_id_seq TO web_usr;
GRANT ALL ON TABLE public.cxgn_bac_pipeline_genbank_log TO web_usr;
GRANT ALL ON SEQUENCE public.cxgn_bac_pipeline_genbank_log_id_seq TO web_usr;
GRANT ALL ON TABLE public.cxgn_bac_pipeline_loading_log TO web_usr;
GRANT ALL ON SEQUENCE public.cxgn_bac_pipeline_loading_log_id_seq TO web_usr;
GRANT ALL ON TABLE public.cxgn_bac_pipeline_processing_log TO web_usr;
GRANT ALL ON SEQUENCE public.cxgn_bac_pipeline_processing_log_id_seq TO web_usr;
GRANT ALL ON TABLE public.cxgn_indexedlog_test_feel_free_to_delete_me TO web_usr;
GRANT ALL ON SEQUENCE public.db_db_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.dbxref_dbxref_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.dbxrefprop TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.environment TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.environment_cvterm TO web_usr;
GRANT SELECT ON SEQUENCE public.environment_cvterm_environment_cvterm_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE public.environment_environment_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.enzyme_restriction_sites TO web_usr;
GRANT SELECT ON TABLE sgn.family TO web_usr;
GRANT SELECT,DELETE ON TABLE public.family TO web_usr;
GRANT SELECT ON TABLE sgn.family_build TO web_usr;
GRANT SELECT,DELETE ON TABLE public.family_build TO web_usr;
GRANT SELECT ON TABLE sgn.family_member TO web_usr;
GRANT SELECT,DELETE ON TABLE public.family_member TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_cvterm_dbxref TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_cvterm_pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_cvtermprop TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.feature_dbxref_feature_dbxref_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.feature_feature_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.feature_genotype TO web_usr;
GRANT SELECT ON SEQUENCE public.feature_genotype_feature_genotype_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_relationship TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_relationship_pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_relationshipprop TO web_usr;
GRANT SELECT,DELETE ON TABLE public.feature_relationshipprop_pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.featureloc_pub TO web_usr;
GRANT ALL ON TABLE public.featureprop_json TO web_usr;
GRANT USAGE ON SEQUENCE public.featureprop_json_featureprop_json_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.featureprop_pub TO web_usr;
GRANT SELECT,DELETE ON TABLE public.forward_amplicon_sequence_information TO web_usr;
GRANT SELECT,DELETE ON TABLE public.forward_amplicon_sequence_markers TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_band TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_build TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_build_fpc_fingerprint TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_contig TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_contig_clone TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_fingerprint TO web_usr;
GRANT SELECT,DELETE ON TABLE public.fpc_series TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.genotype_genotype_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE ON TABLE public.genotypeprop TO web_usr;
GRANT USAGE ON SEQUENCE public.genotypeprop_genotypeprop_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.gff3atts TO web_usr;
GRANT SELECT,DELETE ON TABLE public.gff3view TO web_usr;
GRANT DELETE ON TABLE public.gff_meta TO web_usr;
GRANT SELECT,DELETE ON TABLE public.glossary TO web_usr;
GRANT ALL ON TABLE public.itag_loading_log TO web_usr;
GRANT ALL ON SEQUENCE public.itag_loading_log_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_geolocation TO web_usr;
GRANT SELECT,DELETE ON TABLE public.marker_names TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_protocolprop TO web_usr;
GRANT ALL ON TABLE public.phenotypeprop TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stockprop TO web_usr;
GRANT SELECT,DELETE ON TABLE public.materialized_view TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.matviews TO web_usr;
GRANT ALL ON SEQUENCE public.matviews_mv_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_contact TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_contact_nd_experiment_contact_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_dbxref TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_dbxref_nd_experiment_dbxref_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_genotype_nd_experiment_genotype_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_nd_experiment_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_phenotype_nd_experiment_phenotype_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_project_nd_experiment_project_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_protocol_nd_experiment_protocol_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_pub TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_pub_nd_experiment_pub_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_stock_dbxref TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_stock_dbxref_nd_experiment_stock_dbxref_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_stock_nd_experiment_stock_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experiment_stockprop TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experiment_stockprop_nd_experiment_stockprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_experimentprop TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_experimentprop_nd_experimentprop_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_geolocation_nd_geolocation_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_geolocationprop TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_geolocationprop_nd_geolocationprop_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_protocol_nd_protocol_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_protocol_reagent TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_protocol_reagent_nd_protocol_reagent_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_protocolprop_nd_protocolprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_reagent TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_reagent_nd_reagent_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_reagent_relationship TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_reagent_relationship_nd_reagent_relationship_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.nd_reagentprop TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.nd_reagentprop_nd_reagentprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.organism TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.organism_dbxref TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.organism_dbxref_organism_dbxref_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.organism_organism_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.organism_relationship TO web_usr;
GRANT SELECT,DELETE ON TABLE public.organismpath TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.organismprop TO web_usr;
GRANT USAGE,UPDATE ON SEQUENCE public.organismprop_organismprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.phendesc TO web_usr;
GRANT SELECT ON SEQUENCE public.phendesc_phendesc_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.phenotype_comparison TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.phenotype_comparison_cvterm TO web_usr;
GRANT SELECT ON SEQUENCE public.phenotype_comparison_cvterm_phenotype_comparison_cvterm_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE public.phenotype_comparison_phenotype_comparison_id_seq TO web_usr;
GRANT ALL ON TABLE public.phenotype_cvterm TO web_usr;
GRANT USAGE ON SEQUENCE public.phenotype_cvterm_phenotype_cvterm_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.phenotype_phenotype_id_seq TO web_usr;
GRANT USAGE ON SEQUENCE public.phenotypeprop_phenotypeprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.phenstatement TO web_usr;
GRANT SELECT ON SEQUENCE public.phenstatement_phenstatement_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.phylonode TO web_usr;
GRANT DELETE ON TABLE public.phylonode_dbxref TO web_usr;
GRANT SELECT,DELETE ON TABLE public.phylonode_organism TO web_usr;
GRANT DELETE ON TABLE public.phylonode_pub TO web_usr;
GRANT DELETE ON TABLE public.phylonode_relationship TO web_usr;
GRANT DELETE ON TABLE public.phylonodeprop TO web_usr;
GRANT DELETE ON TABLE public.phylotree TO web_usr;
GRANT DELETE ON TABLE public.phylotree_pub TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.project_contact TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.project_contact_project_contact_id_seq TO web_usr;
GRANT USAGE ON SEQUENCE public.project_project_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.project_pub TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.project_pub_project_pub_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.project_relationship_project_relationship_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.projectprop_projectprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.pub_dbxref TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.pub_dbxref_pub_dbxref_id_seq TO web_usr;
GRANT ALL ON SEQUENCE public.pub_pub_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.pub_relationship TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.pubabstract TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.pubabstract_pubabstract_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.pubauthor TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE public.pubauthor_pubauthor_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.pubprop TO web_usr;
GRANT SELECT,DELETE ON TABLE public.resource_file TO web_usr;
GRANT SELECT,DELETE ON TABLE public.signalp TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock_cvterm TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_cvterm_stock_cvterm_id_seq TO web_usr;
GRANT ALL ON TABLE public.stock_cvtermprop TO web_usr;
GRANT USAGE ON SEQUENCE public.stock_cvtermprop_stock_cvtermprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock_dbxref TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_dbxref_stock_dbxref_id_seq TO web_usr;
GRANT DELETE ON TABLE public.stock_dbxrefprop TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock_genotype TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_genotype_stock_genotype_id_seq TO web_usr;
GRANT ALL ON TABLE public.stock_pub TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_pub_stock_pub_id_seq TO web_usr;
GRANT DELETE ON TABLE public.stock_relationship_cvterm TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stock_relationship_pub TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_relationship_pub_stock_relationship_pub_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_relationship_stock_relationship_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stock_stock_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stockcollection TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stockcollection_stock TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stockcollection_stock_stockcollection_stock_id_seq TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stockcollection_stockcollection_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stockcollectionprop TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stockcollectionprop_stockcollectionprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.stockprop_pub TO web_usr;
GRANT SELECT,USAGE ON SEQUENCE public.stockprop_pub_stockprop_pub_id_seq TO web_usr;
GRANT ALL ON SEQUENCE public.stockprop_stockprop_id_seq TO web_usr;
GRANT SELECT,DELETE ON TABLE public.tableinfo TO web_usr;
GRANT DELETE ON TABLE public.tmp_cds_handler TO web_usr;
GRANT DELETE ON TABLE public.tmp_cds_handler_relationship TO web_usr;
GRANT DELETE ON TABLE public.tmp_gff_load_cache TO web_usr;
GRANT SELECT,DELETE ON TABLE public.unigene_dbxref TO web_usr;
GRANT SELECT,DELETE ON TABLE public.unigene_relations TO web_usr;
GRANT SELECT,DELETE ON TABLE public.unigene_signalp TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.accession TO web_usr;
GRANT ALL ON SEQUENCE sgn.accession_accession_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.accession_names TO web_usr;
GRANT ALL ON SEQUENCE sgn.accession_names_accession_name_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.annotation_target_type TO web_usr;
GRANT ALL ON SEQUENCE sgn.annotation_target_type_annotation_target_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.authors TO web_usr;
GRANT ALL ON SEQUENCE sgn.authors_author_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.blast_annotations TO web_usr;
GRANT ALL ON SEQUENCE sgn.blast_annotations_blast_annotation_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.blast_db TO web_usr;
GRANT SELECT ON TABLE sgn.blast_db_blast_db_group TO web_usr;
GRANT ALL ON SEQUENCE sgn.blast_db_blast_db_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.blast_db_group TO web_usr;
GRANT SELECT ON TABLE sgn.blast_db_organism TO web_usr;
GRANT SELECT ON TABLE sgn.blast_defline TO web_usr;
GRANT ALL ON SEQUENCE sgn.blast_defline_defline_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.blast_hits TO web_usr;
GRANT ALL ON SEQUENCE sgn.blast_hits_blast_hit_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.blast_targets TO web_usr;
GRANT ALL ON SEQUENCE sgn.blast_targets_blast_target_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.cds TO web_usr;
GRANT ALL ON SEQUENCE sgn.cds_cds_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.clone TO web_usr;
GRANT ALL ON SEQUENCE sgn.clone_clone_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.cloning_vector TO web_usr;
GRANT ALL ON SEQUENCE sgn.cloning_vector_cloning_vector_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.common_name TO web_usr;
GRANT ALL ON SEQUENCE sgn.common_name_common_name_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.common_nameprop TO web_usr;
GRANT SELECT ON TABLE sgn.cos_markers TO web_usr;
GRANT ALL ON SEQUENCE sgn.cos_markers_cos_marker_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.cosii_ortholog TO web_usr;
GRANT ALL ON SEQUENCE sgn.cosii_ortholog_cosii_unigene_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_linkage_groups TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_linkage_groups_lg_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_map_cross TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_map_cross_map_cross_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_mapdata TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_mapdata_loc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_maps TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_maps_map_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_marker_confidences TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_marker_confidences_confidence_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_marker_locations TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_marker_locations_marker_location_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_marker_types TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_marker_types_marker_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.deprecated_markers TO web_usr;
GRANT ALL ON SEQUENCE sgn.deprecated_markers_marker_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.derived_from_source TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn.derived_from_source_derived_from_source_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.domain TO web_usr;
GRANT ALL ON SEQUENCE sgn.domain_domain_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.domain_match TO web_usr;
GRANT ALL ON SEQUENCE sgn.domain_match_domain_match_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.enzyme_restriction_sites TO web_usr;
GRANT SELECT ON TABLE sgn.enzymes TO web_usr;
GRANT ALL ON SEQUENCE sgn.enzymes_enzyme_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.est TO web_usr;
GRANT SELECT ON TABLE sgn.est_dbxref TO web_usr;
GRANT SELECT ON TABLE sgn.ests_mapped_by_clone TO web_usr;
GRANT ALL ON SEQUENCE sgn.ests_mapped_by_clone_embc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.experiment_type TO web_usr;
GRANT ALL ON SEQUENCE sgn.experiment_type_experiment_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.facility TO web_usr;
GRANT ALL ON SEQUENCE sgn.facility_facility_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.family_build_family_build_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.family_family_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.family_member_family_member_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.family_tree TO web_usr;
GRANT SELECT ON TABLE sgn.fish_chromatin_density_constants TO web_usr;
GRANT SELECT ON TABLE sgn.fish_experimenter TO web_usr;
GRANT ALL ON SEQUENCE sgn.fish_experimenter_fish_experimenter_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.fish_file TO web_usr;
GRANT ALL ON SEQUENCE sgn.fish_file_fish_file_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.fish_image TO web_usr;
GRANT SELECT ON TABLE sgn.fish_karyotype_constants TO web_usr;
GRANT SELECT ON TABLE sgn.fish_karyotype_constants_old TO web_usr;
GRANT SELECT ON TABLE sgn.fish_result TO web_usr;
GRANT SELECT ON TABLE sgn.fish_result_composite TO web_usr;
GRANT ALL ON SEQUENCE sgn.fish_result_fish_result_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.fish_result_image TO web_usr;
GRANT SELECT ON SEQUENCE sgn.fish_result_image_fish_result_image_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.go TO web_usr;
GRANT ALL ON SEQUENCE sgn.go_go_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.group_linkage TO web_usr;
GRANT ALL ON SEQUENCE sgn.group_linkage_group_linkage_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.groups TO web_usr;
GRANT ALL ON SEQUENCE sgn.groups_group_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.id_linkage TO web_usr;
GRANT ALL ON SEQUENCE sgn.id_linkage_id_linkage_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.il_info TO web_usr;
GRANT SELECT ON TABLE sgn.interpro TO web_usr;
GRANT SELECT ON TABLE sgn.interpro_go TO web_usr;
GRANT ALL ON SEQUENCE sgn.interpro_go_interpro_go_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.interpro_interpro_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn.library TO web_usr;
GRANT ALL ON SEQUENCE sgn.library_library_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.linkage_group TO web_usr;
GRANT ALL ON SEQUENCE sgn.linkage_group_lg_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.loc_types TO web_usr;
GRANT ALL ON SEQUENCE sgn.loc_types_loc_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.manual_annotations TO web_usr;
GRANT ALL ON SEQUENCE sgn.manual_annotations_manual_annotations_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.manual_censor_reasons TO web_usr;
GRANT ALL ON SEQUENCE sgn.manual_censor_reasons_censor_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.map TO web_usr;
GRANT ALL ON SEQUENCE sgn.map_map_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.map_version TO web_usr;
GRANT ALL ON SEQUENCE sgn.map_version_map_version_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.marker TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.marker_alias TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_alias_alias_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.marker_collectible TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_collectible_marker_collectible_dummy_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.marker_collection TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_collection_mc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.marker_confidence TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_confidence_confidence_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.marker_derived_from TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn.marker_derived_from_marker_derived_dummy_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.marker_experiment TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_experiment_marker_experiment_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.marker_location TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_location_location_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.marker_marker_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.marker_to_map TO web_usr;
GRANT SELECT ON TABLE sgn.metadata TO web_usr;
GRANT ALL ON SEQUENCE sgn.metadata_metadata_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.microarray TO web_usr;
GRANT ALL ON SEQUENCE sgn.microarray_microarray_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.misc TO web_usr;
GRANT ALL ON SEQUENCE sgn.misc_misc_unique_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn.organism TO web_usr;
GRANT ALL ON SEQUENCE sgn.organism_organism_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.organismgroup TO web_usr;
GRANT SELECT ON TABLE sgn.organismgroup_member TO web_usr;
GRANT SELECT ON TABLE sgn.p_markers TO web_usr;
GRANT ALL ON SEQUENCE sgn.p_markers_pid_seq TO web_usr;
GRANT SELECT ON TABLE sgn.pcr_exp_accession TO web_usr;
GRANT ALL ON SEQUENCE sgn.pcr_exp_accession_pcr_exp_accession_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.pcr_experiment TO web_usr;
GRANT ALL ON SEQUENCE sgn.pcr_experiment_pcr_experiment_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.pcr_experiment_sequence TO web_usr;
GRANT SELECT ON SEQUENCE sgn.pcr_experiment_sequence_pcr_experiment_sequence_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.pcr_product TO web_usr;
GRANT ALL ON SEQUENCE sgn.pcr_product_pcr_product_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.primer_unigene_match TO web_usr;
GRANT ALL ON SEQUENCE sgn.primer_unigene_match_primer_unigene_match_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.qc_report TO web_usr;
GRANT ALL ON SEQUENCE sgn.qc_report_qc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.rflp_markers TO web_usr;
GRANT ALL ON SEQUENCE sgn.rflp_markers_rflp_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.rflp_sequences TO web_usr;
GRANT ALL ON SEQUENCE sgn.rflp_sequences_seq_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.rflp_unigene_associations TO web_usr;
GRANT ALL ON SEQUENCE sgn.rflp_unigene_associations_rflp_unigene_assoc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.seqread TO web_usr;
GRANT ALL ON SEQUENCE sgn.seqread_read_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.sequence TO web_usr;
GRANT ALL ON SEQUENCE sgn.sequence_sequence_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.snp TO web_usr;
GRANT SELECT ON TABLE sgn.snp_file TO web_usr;
GRANT SELECT ON SEQUENCE sgn.snp_file_snp_file_id_seq TO web_usr;
GRANT SELECT ON SEQUENCE sgn.snp_snp_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.snpprop TO web_usr;
GRANT SELECT ON SEQUENCE sgn.snpprop_snpprop_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.ssr TO web_usr;
GRANT SELECT ON TABLE sgn.ssr_primer_unigene_matches TO web_usr;
GRANT ALL ON SEQUENCE sgn.ssr_primer_unigene_matches_ssr_primer_unigene_match_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.ssr_repeats TO web_usr;
GRANT ALL ON SEQUENCE sgn.ssr_repeats_repeat_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.ssr_ssr_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.submit_user TO web_usr;
GRANT ALL ON SEQUENCE sgn.submit_user_submit_user_id_seq TO web_usr;
GRANT ALL ON TABLE sgn.taxonomy TO PUBLIC;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn.taxonomy TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn.taxonomy_tax_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.temp_caps_correspondence TO web_usr;
GRANT ALL ON SEQUENCE sgn.temp_caps_correspondence_tcc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.temp_map_correspondence TO web_usr;
GRANT ALL ON SEQUENCE sgn.temp_map_correspondence_tmc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.temp_marker_correspondence TO web_usr;
GRANT ALL ON SEQUENCE sgn.temp_marker_correspondence_tmc_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.tigrtc_index TO web_usr;
GRANT ALL ON SEQUENCE sgn.tigrtc_index_tcindex_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.tigrtc_membership TO web_usr;
GRANT ALL ON SEQUENCE sgn.tigrtc_membership_tigrtc_membership_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.tigrtc_tracking TO web_usr;
GRANT ALL ON SEQUENCE sgn.tigrtc_tracking_tigrtc_tracking_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.tm_markers TO web_usr;
GRANT SELECT ON TABLE sgn.tm_markers_sequences TO web_usr;
GRANT ALL ON SEQUENCE sgn.tm_markers_tm_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.trim_feature TO web_usr;
GRANT ALL ON SEQUENCE sgn.trim_feature_feature_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.trim_feature_types TO web_usr;
GRANT ALL ON SEQUENCE sgn.trim_feature_types_trim_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.types TO web_usr;
GRANT ALL ON SEQUENCE sgn.types_type_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.unigene TO web_usr;
GRANT SELECT ON TABLE sgn.unigene_build TO web_usr;
GRANT ALL ON SEQUENCE sgn.unigene_build_unigene_build_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.unigene_consensi TO web_usr;
GRANT ALL ON SEQUENCE sgn.unigene_consensi_consensi_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn.unigene_member TO web_usr;
GRANT ALL ON SEQUENCE sgn.unigene_member_unigene_member_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn.unigene_unigene_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.bac_status TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.bac_status_bac_status_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.bac_status_log TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.bac_status_log_bac_status_log_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn_people.clone_il_mapping_bin_log TO PUBLIC;
GRANT INSERT,UPDATE ON TABLE sgn_people.clone_il_mapping_bin_log TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.clone_il_mapping_bin_log_sp_clone_il_mapping_bin_log_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn_people.clone_validation_log TO PUBLIC;
GRANT INSERT,UPDATE ON TABLE sgn_people.clone_validation_log TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.clone_validation_log_clone_validation_log_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn_people.clone_verification_log TO PUBLIC;
GRANT INSERT,UPDATE ON TABLE sgn_people.clone_verification_log TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.clone_verification_log_clone_verification_log_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.forum_post TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.forum_post_forum_post_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.forum_topic TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.forum_topic_forum_topic_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.list TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.list_item TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.list_item_list_item_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.list_list_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn_people.sp_clone_il_mapping_segment_log TO PUBLIC;
GRANT INSERT,UPDATE ON TABLE sgn_people.sp_clone_il_mapping_segment_log TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.sp_clone_il_mapping_segment_l_sp_clone_il_mapping_segment_l_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_dataset TO web_usr;
GRANT USAGE ON SEQUENCE sgn_people.sp_dataset_sp_dataset_id_seq TO web_usr;
GRANT SELECT ON TABLE sgn_people.sp_group TO web_usr;
GRANT SELECT ON TABLE sgn_people.sp_group_member TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_login_old TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_login_old_sp_login_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_order TO web_usr;
GRANT USAGE ON SEQUENCE sgn_people.sp_order_sp_order_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_orderprop TO web_usr;
GRANT USAGE ON SEQUENCE sgn_people.sp_orderprop_sp_orderprop_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_organisms TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_organisms_organism_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_organization TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_organization_person TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_organization_person_sp_organization_person_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_organization_sp_organization_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_papers TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_papers_sp_paper_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_person TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_person_organisms TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_person_organisms_sp_person_organisms_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_person_roles TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_person_roles_sp_person_role_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_person_sp_person_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_project TO web_usr;
GRANT SELECT ON TABLE sgn_people.sp_project_il_mapping_clone_log TO PUBLIC;
GRANT INSERT,UPDATE ON TABLE sgn_people.sp_project_il_mapping_clone_log TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.sp_project_il_mapping_clone_l_sp_project_il_mapping_clone_l_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_project_organization TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_project_organization_sp_project_organization_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_project_person TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_project_person_sp_project_person_id_seq TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_project_sp_project_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_roles TO web_usr;
GRANT ALL ON SEQUENCE sgn_people.sp_roles_sp_role_id_seq TO web_usr;
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE sgn_people.sp_token TO web_usr;
GRANT USAGE ON SEQUENCE sgn_people.sp_token_sp_token_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_people.user_map TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_people.user_map_data TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.user_map_data_user_map_data_id_seq TO web_usr;
GRANT SELECT,UPDATE ON SEQUENCE sgn_people.user_map_user_map_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_submit.facility TO web_usr;
GRANT ALL ON SEQUENCE sgn_submit.facility_facility_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_submit.library TO web_usr;
GRANT ALL ON SEQUENCE sgn_submit.library_library_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_submit.seqread TO web_usr;
GRANT ALL ON SEQUENCE sgn_submit.seqread_submit_read_id_seq TO web_usr;
GRANT SELECT,INSERT,UPDATE ON TABLE sgn_submit.submit_user TO web_usr;
GRANT ALL ON SEQUENCE sgn_submit.submit_user_submit_user_id_seq TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fattribute TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fattribute_to_feature TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fdata TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fdna TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fgroup TO web_usr;
GRANT SELECT ON TABLE tomato_gff.fmeta TO web_usr;
GRANT SELECT ON TABLE tomato_gff.ftype TO web_usr;