Page MenuHomePhabricator

Superset set up access for Bree Ryan
Closed, ResolvedPublic

Description

Hi there -- Kira from Finance asked for Bree Ryan to be set up in Superset. She'll need the same access that anyone in Finance has previously had. I will send an email to Lisa separately to ask for approval.

Let me know if you need anything else from me! Thanks.


This is a new access request for bryan. 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
[x] (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] 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

Access approved.

Date: Mon, 18 Nov 2024 17:59:06
From: Lisa Seitz Gruwell
To: Runjini Murthy
Cc: Bree Ryan, Dallas Wisehaupt, Kira Sargatzke
Subject: Re: Access for Bree Ryan

Approved
Sent from my iPhone

      On Nov 18, 2024, at 12:11 PM, Runjini Murthy wrote:

      Hi Lisa,

Just checking to see if this was approved.  Thanks again!

Runjini

On Tue, Nov 5, 2024 at 12:01 PM Runjini Murthy wrote:
      Hi Lisa,

Hope you're well!  

Bree Ryan from the Finance team will need access to Superset to be able to review and pull data.  Could you kindly
approve when you have a moment so we can have her set up?

Thank you so much!
Runjini

Received verification that certificate install went well and login works for superset.

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

Received verification that bryan was added to the okta workflows table.