US 11,991,163 B1
Syncing data warehouse permissions using single sign-on authentication
Donald Huang, San Francisco, CA (US); and James L. Gale, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Dec. 9, 2022, as Appl. No. 18/078,447.
Application 18/078,447 is a continuation of application No. 16/913,168, filed on Jun. 26, 2020, granted, now 11,588,805.
Claims priority of provisional application 62/868,405, filed on Jun. 28, 2019.
This patent is subject to a terminal disclaimer.
Int. Cl. H04L 9/40 (2022.01); G06F 9/54 (2006.01); G06F 16/28 (2019.01); G06F 21/62 (2013.01)
CPC H04L 63/0815 (2013.01) [G06F 9/542 (2013.01); G06F 16/283 (2019.01); G06F 21/6218 (2013.01); H04L 63/102 (2013.01); H04L 63/105 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method of syncing data warehouse permissions using single sign-on (SSO) authentication, the method comprising:
determining that a data warehouse user account of a cloud-based data warehouse corresponds to a data analytics user account of a data analytics service, wherein the data analytics user account has one or more permissions in the data analytics service, and wherein the data warehouse user account and the data analytics user account are authenticated to correspond to a same user using a SSO authentication credential from an SSO authentication provider; and
equalizing the one or more permissions in the data analytics user account and the one or more permissions in the cloud-based data warehouse for the data warehouse user account in response to determining a permission in the cloud-based data warehouse for the data warehouse user account is different than a permission in the data analytics user account.