Page MenuHomePhabricator

Fundraising Access Request for Lauren Nadai
Closed, ResolvedPublic

Description

This is a new access request for Lauren Nadai. They require the following access:

civicrm web access
standard access
donor services access
ssh access - if specific hosts: list here
mysql - if specific hosts or databases: list here
[x ] superset
other: please explain

Please see c-level approval below.

Erica Roden <eroden@wikimedia.org>
Tue, Oct 10, 6:25 PM (7 days ago)
to Lisa, Dallas

Hi Lisa and Dallas,

Per above I've been working with Finance to provide them access to some reports in Superset to make it easier for them to complete their reconciliation. Now that we have the reports created, they'd like to also give the following staff access to Superset:

Julie Ian-Wong and Shaoyan Xu & Lauren Nadai.

Lisa- could you approve this request? Dallas- I'll submit phab tickets for each of these once Lisa approves.

Thanks,
Erica

Lisa Seitz Gruwell
Tue, Oct 10, 6:47 PM (7 days ago)
to me, Dallas

Yes, I approve.


New User Procedure / Checklist

When adding a new user to the fundraising / fr-tech ecosystem, we have a set of places where we need to create accounts and access.

Prerequisites

Before we can take any action to add a user, we need to verify that they are authorized to have such access. This requires confirmation from their manager and approval from the C level that access is approved.

[x] user_verification
Requires: user request
[x] access_rights: letter to C level (currently Lisa) verifying grant of access
[x] account name/contact info: verify on https://collab.wikimedia.org/wiki/Fundraising#Contact_List
[x] (if not advancement) add to okta notify list: create ITS ticket for adding to fr-tech okta notification list

Accounts and Services

[x] client_ssl_cert
Requires: user_verification
[x] cert_setup: generate cert on frpm1001 using ssl_user_admin
[x] account_setup: sms the user the password for the key
[x] follow_on: assist with certificate installation
[x] superset
Requires: client_ssl_cert
[x] account_setup: Create user account. Notify the user of their account name and password.
[x] follow_on: Verify user can log in to https://analytics.frdev.wikimedia.org
[x] archive_access: Add to google drive archive group. https://drive.google.com/drive/folders/0ADWGPlZtksGdUk9PVA

Event Timeline

Dwisehaupt moved this task from Up Next to In Progress on the fundraising-tech-ops board.

SSL client certificate created and sent via email. Password sent via SMS. Superset account created and set with random password.
Password sent via SMS. Email sent with instructions on how to log in to superset and change password. Account added to Analytics
archive drive.

Dwisehaupt updated the task description. (Show Details)
Dwisehaupt moved this task from In Progress to Done on the fundraising-tech-ops board.

Verified access is working.