Abstract: Systems and methods are included for accessing resource objects in a multi-threaded environment. A request is received from a requester to perform an operation with respect to a resource object, where the requested resource object has multiple associations with other objects. A determination as to whether an authorization cache entry corresponding to the requested resource object contains sufficient permission data for granting or denying the request for access to the requested resource object is made. A grant or deny of access to the requested resource object is returned when the authorization cache entry corresponding to the requested resource object contains sufficient permission data.

Abstract: Systems and methods are included for accessing resource objects in a multi-threaded environment. A request is received from a requester to perform an operation with respect to a resource object, where the requested resource object has multiple associations with other objects. A determination as to whether an authorization cache entry corresponding to the requested resource object contains sufficient permission data for granting or denying the request for access to the requested resource object is made. A grant or deny of access to the requested resource object is returned when the authorization cache entry corresponding to the requested resource object contains sufficient permission data.

Abstract: Systems and methods are included for accessing resource objects in a multi-threaded environment. A request is received from a requester to perform an operation with respect to a resource object, where the requested resource object has multiple associations with other objects. A determination as to whether an authorization cache entry corresponding to the requested resource object contains sufficient permission data for granting or denying the request for access to the requested resource object is made. A grant or deny of access to the requested resource object is returned when the authorization cache entry corresponding to the requested resource object contains sufficient permission data.

Abstract: Computer-implemented systems and methods for providing row-level security. A system can be configured to receive a request for data that is contained in tables and to use one or more row-level security policies to augment the received request with one or more row-level security query-related clauses.

Abstract: Systems and methods are included for accessing resource objects in a multi-threaded environment. A request is received from a requester to perform an operation with respect to a resource object, where the requested resource object has multiple associations with other objects. A determination as to whether an authorization cache entry corresponding to the requested resource object contains sufficient permission data for granting or denying the request for access to the requested resource object is made. A grant or deny of access to the requested resource object is returned when the authorization cache entry corresponding to the requested resource object contains sufficient permission data.

Abstract: Computer-implemented systems and methods for providing row-level security. A system can be configured to receive a request for data that is contained in tables and to use one or more row-level security policies to augment the received request with one or more row-level security query-related clauses.

Abstract: A computer-implemented system and method for accessing resource objects wherein the objects have multiple associations and/or parents. Security rules indicate which associations and/or parents of a requested resource object are to be used in determining whether to grant access to the requested resource object.

Abstract: A computer-implemented system and method for accessing resource objects wherein the objects have multiple associations and/or parents. Security rules indicate which associations and/or parents of a requested resource object are to be used in determining whether to grant access to the requested resource object.

Abstract: A system and method for configuring, sequencing and viewing joins in a query is provided. The system includes an advanced joins viewer that may be invoked from an SQL Query Tool. A graphical user interface associated with the advanced joins viewer displays a sequenced vertical tile list of each table and each intermediate result set in a particular query. Through this interface, a user may re-sequence the ordering of the tables and thus reconfigure the intermediate result sets that are generated by the query. The advanced joins viewer enables the independent configuration of the join type and the join relationships for each of the intermediate result sets. An automatic sequencing algorithm is also provided for configuring the ordering of the tables such that the query produces valid SQL.