Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GCconnex mods dev tasks and deliberations #2676

Open
AdiMakkar opened this issue Nov 13, 2024 · 1 comment
Open

GCconnex mods dev tasks and deliberations #2676

AdiMakkar opened this issue Nov 13, 2024 · 1 comment
Assignees

Comments

@AdiMakkar
Copy link
Contributor

AdiMakkar commented Nov 13, 2024

Discussions surrounding dev work for gcconnex decommission, potential tasks breakdown and workflow inspection.

@Phanoix
Copy link
Contributor

Phanoix commented Nov 15, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants