Page MenuHomePhabricator

Fundraising access request for jschoenig
Closed, ResolvedPublic

Description

This is a request to set up Civi and Superset access for Jessica Schoenig, Lead Major and Planned Giving Officer whose first day is today, May 7th, 2024. I will email Lisa Gruwell for C-level approval.


This is a new access request for jschoenig. They require the following access: (Mark the box for each requirement with an x)

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

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
[ ] (if not advancement) add to okta notify list: create ITS ticket for adding to fr-tech's entry in the Okta Workflows Table

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] civicrm
Requires: client_ssl_cert
[x] account_setup: Create user account. This will notify the user via email to update their password.
[x] follow_on: Verify user can log in to https://civicrm.wikimedia.org
[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 renamed this task from Systems access for new employee to Fundraising access request for jschoenig.May 7 2024, 6:03 PM
Dwisehaupt updated the task description. (Show Details)

Approval received.

Date: Tue, 7 May 2024 11:17:37
From: Lisa Seitz Gruwell
To: Amy Parker
Cc: Caitlin Virtue, Dallas Wisehaupt
Subject: Re: Civi access for new employee

Approved
Sent from my iPhone

      On May 7, 2024, at 8:25 AM, Amy Parker wrote:

      Hi, Lisa. 
Our new hire Jessica Schoenig starts today! Can you please approve access for her to Civi and Superset? 

-Amy

@AParker The next step we need is to get their contact info added to the Collab Contact List. At a minium we need: name, city/state/country, mobile phone number, email address.

Once we have that information I can create the client certificate and accounts. I'll follow up in email also.

Just noticed that contact info was updated. Setting up the accounts now.

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

SSL cert created and sent via email. Password sent via SMS. Civi account created with random password. Superset account created with random password. Superset password sent via SMS. Instructions sent via email on how to log into systems and change passwords.

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

Met with jschoenig to set up the ssl cert. Verified access is working to civi and superset.