cagov / caldata-mdsa-caltrans-pems

CalData's MDSA project with Caltrans on Performance Measurement System (PeMS) data
https://cagov.github.io/caldata-mdsa-caltrans-pems/
MIT License
7 stars 0 forks source link

Updating user settings in Snowflake #446

Closed ram-kishore-odi closed 4 weeks ago

ram-kishore-odi commented 4 weeks ago

Updated the user settings for the following users in Snowflake. These users were incorrectly setup initially and hence corrective action is needed

Arman (who recently requested access to CalTrans) Summer & Ram (who were recently added to Snowflake)

The action required is to unset the password and add a login_name parameter with email as the value for all these users. This will ensure that users can only login through OKTA and will disable using username & password login mechanism.

ram-kishore-odi commented 4 weeks ago

The user settings have been updated and I have confirmed that all the users are able to login to Snowflake successfully using OKTA after the updates. One of the users faced issues, probably an intermittent issues, which were later resolved by repeating the updates. Hence this issue can be closed.

ian-r-rose commented 4 weeks ago

Cool, thanks for the update