You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
for creating the read-only user, it would look something like this:
grant select on elgg.* to elgg_readonly@% identified by "read only password";
grant all on elgg.d_elgg_users_sessions to elgg_readonly@%;
grant all on elgg.d_elgg_private_settings to elgg_readonly@%;
grant all on elgg.d_elgg_system_log to elgg_readonly@%;
grant all on elgg.d_elgg_users_entity to elgg_readonly@%;
grant all on elgg.d_elgg_users_remember_me_cookies to elgg_readonly@%;
grant all on elgg.d_elgg_metadata to elgg_readonly@%;
grant all on elgg.d_elgg_metastrings to elgg_readonly@%;
you'd want to be more specific when doing this in prod, like instead of elgg_readonly@`% restricting it to only the web server, but otherwise this would create a DB user that can allow logins but doesn't have enough right to create any content and the app would get a DB error if it tries to do so.
Discussions surrounding dev work for gcconnex decommission, potential tasks breakdown and workflow inspection.
The text was updated successfully, but these errors were encountered: