Patent ID: 11972012
Assignee: SAP SE
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 7:
8. A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for authorization checks of queries in database systems, the operations comprising:
receiving, by a database system, a query;
providing, by the database system, a set of checker objects comprising one or more inner checker objects and an outer checker object, each checker object corresponding to a nested sub-query of the query, each checker object comprising transient data object that stores database catalog objects and respective authorization types that are collected for subsequent authorization;
providing, by the database system, an authorization list associated with the outer checker object; and
executing an authorization check on the query at least partially by:
adding collected objects of each inner checker object to the authorization list,
adding collected objects of the outer checker object to the authorization list, and
determining authorization of an entity based on the authorization list.