Patent ID: 7797339
Filing Date: 2010-09-14
Classification: G06F

Abstract:
1. A computer-implemented method for providing security architecture for a content management system, comprising: receiving a request from a client application to execute an application stored procedure stored in a database management system, wherein the application stored procedure includes a database transaction involving a data object stored in a database within the database management system and is configured to create a record specifying an identifier associated with the data object in an audit log, and wherein the audit log stores a different record for each object involved in one or more database transactions included in the application stored procedure; invoking the application stored procedure; invoking a security check procedure that is configured to perform an access control check based on the identifier specified in the record included in the audit log to determine whether the client application is authorized to access the data object; cleaning the audit log by removing each of the different records for each object involved in the one or more database transactions included in the application stored procedure; returning an access violation error to the client application when the client application is not authorized to access the data object; and displaying the access violation error on a graphical user interface (GUI), wherein the GUI comprises options in a single screen to: select a stored procedure to run, select a path to load additional stored procedures, and run a stored procedure to review the executed results.