1 -- This is a sample file that will create a user 'secure' with full permissions to database 'openemr'
2 -- It also revokes that "ALL privileges" for user 'openemr' and grants permissions to each table individual except for
3 -- users_secure. Running this full script repeatedly will fail as granting an "existing" permission or "revoking" a non-existent permission fails
5 -- Create a new user with full permissions
6 create user 'secure'@'localhost' identified by 'securepassword';
7 GRANT ALL on openemr.* to 'secure'@'localhost';
9 -- Revoke the default openemr user permissions of "all"
10 revoke all on openemr.* FROM 'openemr'@'localhost';
12 -- Grant ALL for each table individually
13 GRANT ALL ON openemr.addresses to 'openemr'@'localhost';
14 GRANT ALL ON openemr.amc_misc_data to 'openemr'@'localhost';
15 GRANT ALL ON openemr.ar_activity to 'openemr'@'localhost';
16 GRANT ALL ON openemr.ar_session to 'openemr'@'localhost';
17 GRANT ALL ON openemr.array to 'openemr'@'localhost';
18 GRANT ALL ON openemr.audit_details to 'openemr'@'localhost';
19 GRANT ALL ON openemr.audit_master to 'openemr'@'localhost';
20 GRANT ALL ON openemr.automatic_notification to 'openemr'@'localhost';
21 GRANT ALL ON openemr.background_services to 'openemr'@'localhost';
22 GRANT ALL ON openemr.batchcom to 'openemr'@'localhost';
23 GRANT ALL ON openemr.billing to 'openemr'@'localhost';
24 GRANT ALL ON openemr.categories to 'openemr'@'localhost';
25 GRANT ALL ON openemr.categories_seq to 'openemr'@'localhost';
26 GRANT ALL ON openemr.categories_to_documents to 'openemr'@'localhost';
27 GRANT ALL ON openemr.chart_tracker to 'openemr'@'localhost';
28 GRANT ALL ON openemr.claims to 'openemr'@'localhost';
29 GRANT ALL ON openemr.clinical_plans to 'openemr'@'localhost';
30 GRANT ALL ON openemr.clinical_plans_rules to 'openemr'@'localhost';
31 GRANT ALL ON openemr.clinical_rules to 'openemr'@'localhost';
32 GRANT ALL ON openemr.code_types to 'openemr'@'localhost';
33 GRANT ALL ON openemr.codes to 'openemr'@'localhost';
34 GRANT ALL ON openemr.config to 'openemr'@'localhost';
35 GRANT ALL ON openemr.config_seq to 'openemr'@'localhost';
36 GRANT ALL ON openemr.customlists to 'openemr'@'localhost';
37 GRANT ALL ON openemr.dated_reminders to 'openemr'@'localhost';
38 GRANT ALL ON openemr.dated_reminders_link to 'openemr'@'localhost';
39 GRANT ALL ON openemr.direct_message_log to 'openemr'@'localhost';
40 GRANT ALL ON openemr.documents to 'openemr'@'localhost';
41 GRANT ALL ON openemr.documents_legal_categories to 'openemr'@'localhost';
42 GRANT ALL ON openemr.documents_legal_detail to 'openemr'@'localhost';
43 GRANT ALL ON openemr.documents_legal_master to 'openemr'@'localhost';
44 GRANT ALL ON openemr.drug_inventory to 'openemr'@'localhost';
45 GRANT ALL ON openemr.drug_sales to 'openemr'@'localhost';
46 GRANT ALL ON openemr.drug_templates to 'openemr'@'localhost';
47 GRANT ALL ON openemr.drugs to 'openemr'@'localhost';
48 GRANT ALL ON openemr.eligibility_response to 'openemr'@'localhost';
49 GRANT ALL ON openemr.eligibility_verification to 'openemr'@'localhost';
50 GRANT ALL ON openemr.employer_data to 'openemr'@'localhost';
51 GRANT ALL ON openemr.enc_category_map to 'openemr'@'localhost';
52 GRANT ALL ON openemr.extended_log to 'openemr'@'localhost';
53 GRANT ALL ON openemr.facility to 'openemr'@'localhost';
54 GRANT ALL ON openemr.facility_user_ids to 'openemr'@'localhost';
55 GRANT ALL ON openemr.fee_sheet_options to 'openemr'@'localhost';
56 GRANT ALL ON openemr.form_dictation to 'openemr'@'localhost';
57 GRANT ALL ON openemr.form_encounter to 'openemr'@'localhost';
58 GRANT ALL ON openemr.form_misc_billing_options to 'openemr'@'localhost';
59 GRANT ALL ON openemr.form_reviewofs to 'openemr'@'localhost';
60 GRANT ALL ON openemr.form_ros to 'openemr'@'localhost';
61 GRANT ALL ON openemr.form_soap to 'openemr'@'localhost';
62 GRANT ALL ON openemr.form_vitals to 'openemr'@'localhost';
63 GRANT ALL ON openemr.forms to 'openemr'@'localhost';
64 GRANT ALL ON openemr.gacl_acl to 'openemr'@'localhost';
65 GRANT ALL ON openemr.gacl_acl_sections to 'openemr'@'localhost';
66 GRANT ALL ON openemr.gacl_acl_seq to 'openemr'@'localhost';
67 GRANT ALL ON openemr.gacl_aco to 'openemr'@'localhost';
68 GRANT ALL ON openemr.gacl_aco_map to 'openemr'@'localhost';
69 GRANT ALL ON openemr.gacl_aco_sections to 'openemr'@'localhost';
70 GRANT ALL ON openemr.gacl_aco_sections_seq to 'openemr'@'localhost';
71 GRANT ALL ON openemr.gacl_aco_seq to 'openemr'@'localhost';
72 GRANT ALL ON openemr.gacl_aro to 'openemr'@'localhost';
73 GRANT ALL ON openemr.gacl_aro_groups to 'openemr'@'localhost';
74 GRANT ALL ON openemr.gacl_aro_groups_id_seq to 'openemr'@'localhost';
75 GRANT ALL ON openemr.gacl_aro_groups_map to 'openemr'@'localhost';
76 GRANT ALL ON openemr.gacl_aro_map to 'openemr'@'localhost';
77 GRANT ALL ON openemr.gacl_aro_sections to 'openemr'@'localhost';
78 GRANT ALL ON openemr.gacl_aro_sections_seq to 'openemr'@'localhost';
79 GRANT ALL ON openemr.gacl_aro_seq to 'openemr'@'localhost';
80 GRANT ALL ON openemr.gacl_axo to 'openemr'@'localhost';
81 GRANT ALL ON openemr.gacl_axo_groups to 'openemr'@'localhost';
82 GRANT ALL ON openemr.gacl_axo_groups_map to 'openemr'@'localhost';
83 GRANT ALL ON openemr.gacl_axo_map to 'openemr'@'localhost';
84 GRANT ALL ON openemr.gacl_axo_sections to 'openemr'@'localhost';
85 GRANT ALL ON openemr.gacl_groups_aro_map to 'openemr'@'localhost';
86 GRANT ALL ON openemr.gacl_groups_axo_map to 'openemr'@'localhost';
87 GRANT ALL ON openemr.gacl_phpgacl to 'openemr'@'localhost';
88 GRANT ALL ON openemr.geo_country_reference to 'openemr'@'localhost';
89 GRANT ALL ON openemr.geo_zone_reference to 'openemr'@'localhost';
90 GRANT ALL ON openemr.globals to 'openemr'@'localhost';
91 GRANT ALL ON openemr.gprelations to 'openemr'@'localhost';
92 GRANT ALL ON openemr.groups to 'openemr'@'localhost';
93 GRANT ALL ON openemr.history_data to 'openemr'@'localhost';
94 GRANT ALL ON openemr.icd10_dx_order_code to 'openemr'@'localhost';
95 GRANT ALL ON openemr.icd10_gem_dx_10_9 to 'openemr'@'localhost';
96 GRANT ALL ON openemr.icd10_gem_dx_9_10 to 'openemr'@'localhost';
97 GRANT ALL ON openemr.icd10_gem_pcs_10_9 to 'openemr'@'localhost';
98 GRANT ALL ON openemr.icd10_gem_pcs_9_10 to 'openemr'@'localhost';
99 GRANT ALL ON openemr.icd10_pcs_order_code to 'openemr'@'localhost';
100 GRANT ALL ON openemr.icd10_reimbr_dx_9_10 to 'openemr'@'localhost';
101 GRANT ALL ON openemr.icd10_reimbr_pcs_9_10 to 'openemr'@'localhost';
102 GRANT ALL ON openemr.icd9_dx_code to 'openemr'@'localhost';
103 GRANT ALL ON openemr.icd9_dx_long_code to 'openemr'@'localhost';
104 GRANT ALL ON openemr.icd9_sg_code to 'openemr'@'localhost';
105 GRANT ALL ON openemr.icd9_sg_long_code to 'openemr'@'localhost';
106 GRANT ALL ON openemr.immunizations to 'openemr'@'localhost';
107 GRANT ALL ON openemr.insurance_companies to 'openemr'@'localhost';
108 GRANT ALL ON openemr.insurance_data to 'openemr'@'localhost';
109 GRANT ALL ON openemr.insurance_numbers to 'openemr'@'localhost';
110 GRANT ALL ON openemr.issue_encounter to 'openemr'@'localhost';
111 GRANT ALL ON openemr.issue_types to 'openemr'@'localhost';
112 GRANT ALL ON openemr.lang_constants to 'openemr'@'localhost';
113 GRANT ALL ON openemr.lang_custom to 'openemr'@'localhost';
114 GRANT ALL ON openemr.lang_definitions to 'openemr'@'localhost';
115 GRANT ALL ON openemr.lang_languages to 'openemr'@'localhost';
116 GRANT ALL ON openemr.layout_options to 'openemr'@'localhost';
117 GRANT ALL ON openemr.lbf_data to 'openemr'@'localhost';
118 GRANT ALL ON openemr.list_options to 'openemr'@'localhost';
119 GRANT ALL ON openemr.lists to 'openemr'@'localhost';
120 GRANT ALL ON openemr.lists_touch to 'openemr'@'localhost';
121 GRANT ALL ON openemr.log to 'openemr'@'localhost';
122 GRANT ALL ON openemr.notes to 'openemr'@'localhost';
123 GRANT ALL ON openemr.notification_log to 'openemr'@'localhost';
124 GRANT ALL ON openemr.notification_settings to 'openemr'@'localhost';
125 GRANT ALL ON openemr.onotes to 'openemr'@'localhost';
126 GRANT ALL ON openemr.openemr_module_vars to 'openemr'@'localhost';
127 GRANT ALL ON openemr.openemr_modules to 'openemr'@'localhost';
128 GRANT ALL ON openemr.openemr_postcalendar_categories to 'openemr'@'localhost';
129 GRANT ALL ON openemr.openemr_postcalendar_events to 'openemr'@'localhost';
130 GRANT ALL ON openemr.openemr_postcalendar_limits to 'openemr'@'localhost';
131 GRANT ALL ON openemr.openemr_postcalendar_topics to 'openemr'@'localhost';
132 GRANT ALL ON openemr.openemr_session_info to 'openemr'@'localhost';
133 GRANT ALL ON openemr.patient_access_offsite to 'openemr'@'localhost';
134 GRANT ALL ON openemr.patient_access_onsite to 'openemr'@'localhost';
135 GRANT ALL ON openemr.patient_data to 'openemr'@'localhost';
136 GRANT ALL ON openemr.patient_reminders to 'openemr'@'localhost';
137 GRANT ALL ON openemr.payment_gateway_details to 'openemr'@'localhost';
138 GRANT ALL ON openemr.payments to 'openemr'@'localhost';
139 GRANT ALL ON openemr.pharmacies to 'openemr'@'localhost';
140 GRANT ALL ON openemr.phone_numbers to 'openemr'@'localhost';
141 GRANT ALL ON openemr.pma_bookmark to 'openemr'@'localhost';
142 GRANT ALL ON openemr.pma_column_info to 'openemr'@'localhost';
143 GRANT ALL ON openemr.pma_history to 'openemr'@'localhost';
144 GRANT ALL ON openemr.pma_pdf_pages to 'openemr'@'localhost';
145 GRANT ALL ON openemr.pma_relation to 'openemr'@'localhost';
146 GRANT ALL ON openemr.pma_table_coords to 'openemr'@'localhost';
147 GRANT ALL ON openemr.pma_table_info to 'openemr'@'localhost';
148 GRANT ALL ON openemr.pnotes to 'openemr'@'localhost';
149 GRANT ALL ON openemr.prescriptions to 'openemr'@'localhost';
150 GRANT ALL ON openemr.prices to 'openemr'@'localhost';
151 GRANT ALL ON openemr.procedure_answers to 'openemr'@'localhost';
152 GRANT ALL ON openemr.procedure_order to 'openemr'@'localhost';
153 GRANT ALL ON openemr.procedure_order_code to 'openemr'@'localhost';
154 GRANT ALL ON openemr.procedure_providers to 'openemr'@'localhost';
155 GRANT ALL ON openemr.procedure_questions to 'openemr'@'localhost';
156 GRANT ALL ON openemr.procedure_report to 'openemr'@'localhost';
157 GRANT ALL ON openemr.procedure_result to 'openemr'@'localhost';
158 GRANT ALL ON openemr.procedure_type to 'openemr'@'localhost';
159 GRANT ALL ON openemr.product_warehouse to 'openemr'@'localhost';
160 GRANT ALL ON openemr.registry to 'openemr'@'localhost';
161 GRANT ALL ON openemr.report_results to 'openemr'@'localhost';
162 GRANT ALL ON openemr.rsa_pairs to 'openemr'@'localhost';
163 GRANT ALL ON openemr.rule_action to 'openemr'@'localhost';
164 GRANT ALL ON openemr.rule_action_item to 'openemr'@'localhost';
165 GRANT ALL ON openemr.rule_filter to 'openemr'@'localhost';
166 GRANT ALL ON openemr.rule_patient_data to 'openemr'@'localhost';
167 GRANT ALL ON openemr.rule_reminder to 'openemr'@'localhost';
168 GRANT ALL ON openemr.rule_target to 'openemr'@'localhost';
169 GRANT ALL ON openemr.sequences to 'openemr'@'localhost';
170 GRANT ALL ON openemr.standardized_tables_track to 'openemr'@'localhost';
171 GRANT ALL ON openemr.supported_external_dataloads to 'openemr'@'localhost';
172 GRANT ALL ON openemr.syndromic_surveillance to 'openemr'@'localhost';
173 GRANT ALL ON openemr.template_users to 'openemr'@'localhost';
174 GRANT ALL ON openemr.transactions to 'openemr'@'localhost';
175 GRANT ALL ON openemr.user_settings to 'openemr'@'localhost';
176 GRANT ALL ON openemr.users to 'openemr'@'localhost';
177 GRANT ALL ON openemr.users_facility to 'openemr'@'localhost';
178 GRANT ALL ON openemr.version to 'openemr'@'localhost';
179 GRANT ALL ON openemr.x12_partners to 'openemr'@'localhost';