IP Library › Granted Patent US 11,689,533
Granted Patent B2
US 11,689,533 · App. 16/933,072 · Granted Jun 27, 2023

Managing worksheet access

Inventors: Julie L. Lemieux (San Francisco, CA); Jason D. Frantz (San Francisco, CA); James L. Gale (San Francisco, CA); Donald Huang (San Francisco, CA)
Assignee: SIGMA COMPUTING, INC.
H04L63/102H04L63/08
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,689,533
App. No.
16/933,072
Granted
Jun 27, 2023
Kind
B2
Abstract

Managing worksheet access including receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database; determining that the first user account is authorized to access the worksheet architecture of the worksheet; determining that the first user account is authorized to access the at least one data set presented by the worksheet; and granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

Claims (38)

1. A method of managing worksheet access, the method comprising:

receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database;

determining that the first user account is authorized to access the worksheet architecture of the worksheet;

determining that the first user account is authorized to access the at least one data set presented by the worksheet, including comparing an identifier of the first user account to identifiers of an authorized set of user accounts for each data source within the database and associated with the at least one data set; and

granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

2. The method of claim 1 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access data sources of the at least one data set, wherein the data sources are within the database.

3. The method of claim 1 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises:

determining that the first user account is not authorized to access data sources of the at least one data set; and

determining that the second user account is authorized to grant access to the data sources of the at least one data set.

4. The method of claim 1 , further comprising denying the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is not authorized to access the at least one data set presented by the worksheet.

5. The method of claim 1 , wherein the at least one data set comprises a first data set from a first data source on the database and a second data set from a second data source on the database, and wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access the first data source and the second data source on the database.

6. The method of claim 1 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is not authorized to access portions of a data source of the data set that are not within the data set presented in the worksheet.

7. The method of claim 1 , wherein granting the first user account access to the worksheet comprises presenting, to a user of the first user account, the at least one data set from the database within the worksheet comprising the worksheet architecture for the at least one data set from the database.

8. An apparatus for managing worksheet access, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:

receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database;

determining that the first user account is authorized to access the worksheet architecture of the worksheet;

determining that the first user account is authorized to access the at least one data set presented by the worksheet, including comparing an identifier of the first user account to identifiers of an authorized set of user accounts for each data source within the database and associated with the at least one data set; and

granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

9. The apparatus of claim 8 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access data sources of the at least one data set, wherein the data sources are within the database.

10. The apparatus of claim 8 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises:

determining that the first user account is not authorized to access data sources of the at least one data set; and

determining that the second user account is authorized to grant access to the data sources of the at least one data set.

11. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the step of denying the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is not authorized to access the at least one data set presented by the worksheet.

12. The apparatus of claim 8 , wherein the at least one data set comprises a first data set from a first data source on the database and a second data set from a second data source on the database, and wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access the first data source and the second data source on the database.

13. The apparatus of claim 8 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is not authorized to access portions of a data source of the data set that are not within the data set presented in the worksheet.

14. The apparatus of claim 8 , wherein granting the first user account access to the worksheet comprises presenting, to a user of the first user account, the at least one data set from the database within the worksheet comprising the worksheet architecture for the at least one data set from the database.

15. A computer program product for managing worksheet access, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:

receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database;

determining that the first user account is authorized to access the worksheet architecture of the worksheet;

determining that the first user account is authorized to access the at least one data set presented by the worksheet, including comparing an identifier of the first user account to identifiers of an authorized set of user accounts for each data source within the database and associated with the at least one data set; and

granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

16. The computer program product of claim 15 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access data sources of the at least one data set, wherein the data sources are within the database.

17. The computer program product of claim 15 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises:

determining that the first user account is not authorized to access data sources of the at least one data set; and

determining that the second user account is authorized to grant access to the data sources of the at least one data set.

18. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the step of denying the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is not authorized to access the at least one data set presented by the worksheet.

19. The computer program product of claim 15 , wherein the at least one data set comprises a first data set from a first data source on the database and a second data set from a second data source on the database, and wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is authorized to access the first data source and the second data source on the database.

20. The computer program product of claim 15 , wherein determining that the first user account is authorized to access the at least one data set presented by the worksheet comprises determining that the first user account is not authorized to access portions of a data source of the data set that are not within the data set presented in the worksheet.

Assignments (2)
SECURITY INTEREST Recorded Aug 1, 2025
From: SIGMA COMPUTING, INC.
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 072316/0724 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 20, 2020
From: LEMIEUX, JULIE L.; FRANTZ, JASON D.; GALE, JAMES L.; HUANG, DONALD
To: SIGMA COMPUTING, INC.
Reel/Frame 053251/0205 →
Continuity (2)
Provisional Application 62913273 · Oct 10, 2019
Related Publication 20210112066A1 · Apr 15, 2021