A portion of the disclosure of this patent document contains material that is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or patent disclosure as it appears in the Patent and Trademark Office, patent file or records, but otherwise reserves all copyrights whatsoever.
Methods and systems for dynamically assessing a permission of a user that one of modifies or adds at least one content change in a source environment; and, in addition, for reporting the dynamic assessment to an administrator based on a triggering event.
Large companies employ numerous employees and these employees operate their respective company's systems to execute a variety of tasks. Such large companies have found that reviewing and monitoring the authorization level of their employees and the executed tasks is time-consuming and inefficient. However, the review of employees and their system usage is important in order to: ensure efficient operation, avoid wasteful overlaps, control the unauthorized sharing of confidential information, and effectively report on compliance with rules by technologies, people, processes, and information.
Accordingly, these large companies have adopted real-time ad-hoc Risk Analysis (RA) software and associate systems to perform these monitoring tasks on their behalf. In Enterprise Resource Planning (ERP) systems, customers use Risk Analysis (RA) to comply with an owner's provided audit requirements. RA is generally implemented to detect Segregation of Duties (SoD) violations, which indicate whether different users and tasks involved in the ERP systems are properly authorized to: create, delete, access (read, write, send), and manipulate different portions of the ERP systems.
When the conventional RA is implemented, analysis can be extremely time-consuming. Moreover, the time-consuming analysis must be completed in order for the customer to be provided with the audit report. Each time the user requests the report, a full analysis of the system must be repeated. The audit report is typically in the form of an SoD analysis report.
ERP systems performing the conventional RA generally access, analyze, and report the status of RA applications in accordance with the following. First, each database that is a part of the ERP system and governed by the RA audit must be accounted for. Then, each accounted for database has all of its data rules and authorization rules synchronized onto a backend environment. After the full synchronization of all of the databases, the backend system compares the synchronized data rules and authorization rules to a pre-defined set of rules stored at the backend.
The analysis of the conventional RA is generally time consuming for several reasons. One reason is that each time an RA is executed, the RA acts as a trigger to initiate the RA process. Only upon the trigger does the ERP system identify which data tables are needed and then proceeds to pull relevant data from those identified data tables in the source systems. After having identified and accessed the relevant data, the ERP system proceeds to check each role, action, and permission level from the accessed data according to a pre-defined set of rules.
The comparison results from the check are stored and used to generate the SoD analysis report. Each time, however, a database associated with the ERP system expands to account for data developments or changes in local infrastructure associated with the company, additional unknown and unconfirmed data exists locally in the source system that has not been subjected to a RA by the ERP system.
The assessment report is historically only stored, in conventional RA, after a full compare is run. The assessment report is then stored locally upon the customer's device. The assessment report includes information regarding what violation occurred, which parties were responsible, and which tasks triggered the violation. In convention applications, violation reports are often presented to the users at consistent intervals. For example, violation reports may be presented month by month.
In many environments, such as Information Technology (IT) environments, multiple ERP systems are used as source data based on customer needs and requirements. Similarly, customer needs and requirements result in the multiple ERP systems handling a high volume of RAs. Due to the voluminous number of ERP systems needed for these environment systems, conventional RA has not been scalable.
In addition, scalability is further complicated given that high volume maintenance activities are often required. In some circumstances, the amount of maintenance is driven due to the various plug-in dependencies of each of, or some of, the ERP systems and edge components associated with the ERP systems. Conventional RA, sometimes referred to herein as ad-hoc RA, is also not scalable because any synchronization of the ERP systems requires a great deal of time. In many environments, the data to be accessed for the RA is voluminous and constantly increasing as the database tables grow to support various customer needs.
Furthermore, the procedure to execute the real-time ad-hoc RA requires a large amount of memory on the backend server environment. The generation of the SoD analysis report further consumes significant application-specific programming memory.
Accordingly, there is a need for methods and systems to dynamically assess user permissions and report the assessment to an administrator of a system, without delay, in response to a triggering event.
Example embodiments of the present invention provide for methods and systems for dynamically assessing a permission of a user that modifies or adds at least one content change in a source environment; and, in addition, for reporting the dynamic assessment to an administrator based on a triggering event.
The dynamic SoD RA model described herein is, in some embodiments, executed on a complete cloud based software as a service (SaaS). In some embodiments, a portion of the SoD RA model is executed on the cloud. In some embodiments, the SoD RA model is executed entirely in a wired network. The dynamic SoD RA model described herein is scalable and secure. In particular, the dynamic SoD RA model described herein is used to solve issues arising in access control as they relate to governance, risk, and compliance (GRC). The invention operates in real-time and remains scalable irrespective of the number of systems implemented in the governance hierarchy. Similarly, the invention remains scalable irrespective of the amount of data controlled and/or reviewed by the governance hierarchy.
In some embodiments, the SoD RA model described herein is implementable in an environment with mixed tenants. In other words, in scenarios in which an overarching governance is desirable but in which the different entities do not wish to or are unable to share proprietary and/or confidential information, the SoD RA model interfaces with a relational database management system to encrypt the data of the mixed tenants as necessary. In one embodiment, the relational database management system performing the encryption with and according to the SoD RA model is SAP HANA (high-performance analytical appliance).
The solution provided by the dynamic SoD RA model described herein is capable of operating alongside a conventional RA model in a seamless manner.
The dynamic SoD RA model is integrated into a relational database management system for easy on-loading and off-loading of data and package simplification. In an example embodiment, the SoD RA model is integrated with S4/HANA in either on-premises solutions or on-cloud solutions.
The dynamic segregation of duties risk assessment system 100 includes a source system and a target system. Authorization data is stored on the source system. The target system includes a target database and associated processing device, and the source system includes a collection of source databases and associated processing devices. The authorization data includes, in some embodiments, role information. In some embodiments, the authorization data includes profile information. In an example embodiment, the authorization data includes both role information and profile information. The authorization data, or a relevant portion thereof, is replicated by the dynamic segregation of duties risk assessment system. Replication is performed by a replication mechanism that is capable of being selected by one of ordinary skill in the art. In an example embodiment, the replication mechanism is SLT (SAP Landscape Transformation). The replication is performed by replicating objects and/or data from the source system onto a target system as objects and/or data. The target system is capable of executing the SoD RA model as described herein, and the target system has access to the predefined authorization data. In some embodiments, the target system is HANA.
The replication, by the replication mechanism, is triggered automatically whenever authorization data is provisioned and/or changed. For example, a replication trigger is generated when a user of the source system creates a new role. In another example, a replication trigger is generated when a user of the source system changes the authorization settings associated with a particular previously established profile. The rules for establishment of a trigger are maintained on the target system, or on a database accessible by the target system. In an example embodiment, the trigger rules are maintained in SAP Access Control on HANA. The trigger rules are configurable or updateable by a designated administration. The trigger rules are otherwise configurable or updateable according to the governance provided in the predefined rules.
Based on the role of the replication trigger, the trigger is executed in real-time based on the permission assessment. Therefore, the execution of the trigger is performed in real-time and is executed independently from a trigger that initiates reporting. Due to the execution of the replication trigger on an events-driven basis, there is no need to download and execute an entire comparison upon the trigger, as was previously performed by the conventional model. The permission assessment is performed at the permission group level. The permission group level is the lowest granular level in the permission hierarchy, and is not part of the access control levels (i.e., risk/rule level). The permission assessment is constantly executed in the background of the ERP system, even before a consumer executes a request for an audit report.
Role information contains authorization data or objects that indicate to what extent users can access, modify, or influence other data. For example, roles limit a user's ability to access or manipulate transactions, reports, and web-based applications. Users are, as is generally known in information systems, entered into a role based system such that their formal name is associated with a username and a role. This system is formally executed by associations of objects within object classes such that each user is associated with at least one authorization object and at least one authorization role. Multiple roles may form a composite role that is in turn associated with a plurality of authorization objects and authorization roles.
In some embodiments, the replication trigger is driven by a Perfectly Functionally Co-coordinating Group (PFCG) role change. In some embodiments, the replication trigger is driver by an AC function change. In some embodiments, the replication trigger is driven by both the PFCG role change and the AC function change. A change, as described herein, refers to when the permission content for a role or function is added, deleted, or modified. The permission content change occurs generally upon a transaction between a consumer or administrator and the associated database. Upon such changes, the replication trigger is executed and a delta assessment is triggered. A delta assessment determines only the operations necessary to update the current objects from the source system. After completion of the assessment, the assessment result is stored locally for reporting to the consumer, typically at a later point in time.
When the RA is executed during runtime, the violation reports are generated from the information available in the local storage. The recovery of data from local storage, without a comparison at the time of the request, results in a minimal processing time.
A significant portion of the system 100 is hosted by a network server 102. In some embodiments, the network server 102, sometimes described herein as a platform, is a Web based service-oriented application and integration platform. In some embodiments, platform 102 is SAP NetWeaver. Permission Assessment Engine 104 is hosted by the network server 102. Reporting Engine 106 is also supported by the network server 102. Network server 102 further hosts a relational database management system 108.
Relational database management system 108, is in some embodiments, SAP HANA. The relational database management system 108 is used to store at least: a Governance, Risk, and Compliance (GRC) Repository 110, Function Content 112, and Role Content 114. Alternatively, or in additional embodiments, the relational database management system 108 includes at least one additional database that is used to store at least: a GRC Repository 110, Function Content 112, and Role Content 114.
GRC Repository 110 includes at least data storage related to Assessment Results 116, Rules 118, and Users 120. In some embodiments, different data storage is provided for each of the Assessment Results 116, Rules 118, and Users 120. In some embodiments, shared data storage is provided for the Rules 118 and the Users 120. Function Content 112 includes in some embodiments at least one function 122. In some embodiments, Function Content 112 includes a plurality of functions including function 122, function 2124, and up to function n 126. Role Content 114 includes at least one of a database relating to: Security Risk Management (SRM) 128, Enterprise Resource Planning (ERP) 130, and Customer Relationship Management (CRM) 132.
A user interface 136 is available on the user-end shell 146. In some embodiments, the user interface 136 includes FIORI Application SAP UI5. In some embodiments, the user interface is a cross platform user interface. In some embodiments, the user interface is capable of integration with any traditional computing platform, including mobile devices, tablets, laptops, and desktop computers.
Using a service that has a standardized protocol for creating and consuming data APIs, data can be consumed from the user interface. In some embodiments, the service having the standardized protocol is OData. In other embodiments, another standardized protocol known to those of ordinary skill in the art is used for this consumption process. In some embodiments, the service having the standardized protocols builds off of other established core protocols such as, but not limited to, Hyper-Text Transfer Protocol (HTTP) and Representational State Transfer (REST) methodologies.
Using a gateway 140 included on the network server 102, data is consumed from the tables available through the user interface 136 by a service. In an example embodiment, the gateway 140 is the Advanced Business Application Programming (ABAP) Gateway. In some embodiments, the data consumption is completed by an ODATA service. In some embodiments, files can be uploaded and or downloaded by a user according to various manipulations executed by the user within the user interface 136 on the shell 146. These files can include data presented with extensions including but not limited to: .doc, .docx, .xls, .xlsx, .ppt, .pptx, .xml, .msg, .pdf, and .txt.
The user-end shell 146, which includes the user interface and which supports any applicable analytics applications needed for the reporting engine, is in some example embodiments a deployable set of pre-packaged applications. In some embodiments, the user-end shell 146 is SAP Fiori. In some embodiments, the user-end shell requires that a user provide authentication, including a user ID that is associated with at least one role, in order to access the user interface.
The system further includes a data information management system (DIMS) 142. In some embodiments, the DIMS is an SLT Replicator. SLT is an example standard SAP landscape replication mechanism. SLT operates based on publication and subscription of different communication lines to the replication mechanism. The utilized replication mechanism creates the same object that was established in the ERP source system and copies it into the appropriate hierarchical position within the target system. In an example embodiment, the object is copied into an appropriate hierarchical position within the relational database. SLT ensures that every single change that occurs within the ERP is mirrored in HANA. Other possible replication mechanisms include the Extract, Transform, Load (ETL) mechanism. Moreover, the HANA cloud interface connectivity can be used as a replication mechanism.
In other embodiments, other replication mechanisms are implemented. The DIMS is, in some embodiments, integrated onto the network server 102. In other embodiments, the DIMS is provided on another server or system external to the network server 102 as is shown in
The system further includes a platform for applications 144. The platform for applications 144 includes an application server as well as the various applications. In some embodiments, the platform for applications is the R/3 Basis system. At least one application is hosted on the platform, and the platform is capable of hosting any number of applications, including applications related to at least financial accounting, logistics, and human resources management. In some embodiments, applications available in the platform are pre-packaged and/or available to the user based on programs written by the user/designer in the ABAP Workbench using ABAP. As part of R/3 Basis system there is included in the platform for applications 144 a further storage area, an R/3 Repository, in which individual components of application programs are made available. In some embodiments, ERP software is made available through the R/3 Basis system such that processes related to at least one of procurement, manufacturing, services, sales, finances, and human resources are streamlined.
To provide the designed assessment of the stored assessment results, the system further includes, as part of the shell 146, at least one analytics application 138. In some embodiments, the analytics 138 includes at least Lumira Analytics. Data visualization software, such as Lumira, allows for the provided data to represent the final analysis of the assessment results to the user. In some embodiments, the analytics applications can be implemented with or without the SAP HANA in-memory platform.
Within the system described in
A role (or function) that is newly added or changed in the control access must be checked according to permission levels, including Rules and/or Users. In some embodiments, the newly edited roles may affect the relative hierarchical relationship of more than one user. In an example environment having a first user and a second user, both the first user and the second user are employees of the same company and employed at the same company location. The first user is a first year employee and has a basic degree of authority to access and edit information associated with the company databases. The second user is an administrator and has higher degree of authority to access and edit information associated with the company databases, as compared to the first user. In this scenario, if the first user accesses and edits role information to provide himself with greater authority, or if this user attempts to perform a task beyond his authorization credentials, this triggers the permission assessment engine because the first user has generated a content change to the Role Content. Therefore, this alteration triggers an assessment to validate or check the role of the first user.
Action Map 202 includes Action Functions. Action Functions are included, within the system of
Permission Map 204 includes Permission Functions. Permission Functions are included, within the system of
Permission Value Map 206 contains various Permission Values. Permission Values are included, within the system of
Permission Value Details Map 208 contains a snapshot of the relationships between Permission Value families and an Action Assessment ID. As stated in the foregoing, Permission Values are included, within the system of
Role with Assessments Map 210 contains Role information. Role information is included, within the system of
Integrated into the Target System 304 is a Replication Control System 306, a Relational Database System 308, and a Governance System 310. In some embodiments, at least one of Replication Control System 306, Relational Database System 308, and Governance System 310 further includes an additional database. In an example embodiment, Replication Control System 306 is SLT System 306, Relational Database System 308 is SAP HANA System 308, and Governance System 310 is SAP GRC AC System 310. Governance System 310 can further include AC Component 322, GRC Common Component 324, and SAP Basis 326. Each of these sub-systems within the Target System 304 including at least the Replication Control System 306, the Relational Database System 308, and the Governance System 310 is controlled and executed by at least one processing device. In some embodiments, the processing device is included on a server and the processing device is in communication with a computer-readable medium. The computer-readable medium may be a database internal or external to the processing device or external storage means. The computer-readable medium may include instructions executable by the processing device such that when the processing device executes various portions of the instructions, the instructions cause the processing device to perform the various methods described herein.
Integrated into the Source System 302 are a number of modules, including any of Read Modules 312, Application Tables 314, DB Trigger 316, and Logging Tables 318. When a content change to one of the Role or the Function content occurs, the data that has been sent over the connection 320 triggers a check by the Permission Assessment Engine. The modules of the Source System are controlled and executed by at least one processing device. In some embodiments, the processing device is included on a server and the processing device is in communication with a computer-readable medium. The computer-readable medium may be a database internal or external to the processing device or external storage means. The computer-readable medium may include instructions executable by the processing device such that when the processing device executes various portions of the instructions, the instructions cause the processing device to perform the various methods described herein.
The Source System 302 and the Target System 304 are configured to communicate with one another. In some embodiments, this communication is performed over a wired connection. In some embodiments, the communication between the Source System 302 and the Target System 304 is performed over a wireless connection. In some embodiments, the Target System 304 is sourced in the Cloud 328. In some embodiments, both of the Source System 302 and the Target System 304 are sourced in the Cloud 328.
At 402, the source system is checked for new role information and new function information. The source system is further checked for modified role information and modified function information. In some embodiments, a single source system is checked. In some embodiments, multiple source systems are checked. If multiple source systems are checked, they are checked either in series or in parallel.
At 404, it is determined whether a modified or new role or function information is available at the source system. If the outcome of the determination is that no updated information is available at the source system, the method returns to 402. If the outcome of the determination is that either the modified or new role/function information is available at the source system, the method proceeds to 406.
After the determination is made that new role or new function information is available, step 406 is initiated. The determined new role or function information is replicated into the respective target system role or function information. The replication is performed so as to preserve any associated hierarchical information. In some embodiments, only the new information is replicated using a delta replication mechanism.
At 408, it is determined based on the replication which target roles or functions have been modified or provisioned. The analysis of target roles or functions is performed in real time.
For those replicated target roles or functions, at 410, a permission assessment is performed. In some embodiments, only a delta assessment is triggered when the permission content has changed. The permission assessment is performed at the permission group level, which is the lowest granular level, as opposed to the Risk/Rule level.
After the trigger is executed, it is determined whether or not any changes have been identified in the backend environment. The trigger is, furthermore, specific to the user and the object that were involved in the action.
The trigger performs delta change determinations as opposed to requiring that the entire global database is reviewed for changes on the trigger. A delta check on the object is performed, via a mitigation policy, upon the trigger. When a delta change has been determined within the objects reviewed, the system flags the features that have been added, deleted, or modified in the delta change.
At 412, the results of the permission assessment are stored locally on the target system for reporting. In some embodiments, the results of the permission assessment are automatically generated into a report. In some embodiments, the results of the permission assessment are stored in anticipation of updates prior to a RA request from a user.
At 502, the method described in
A determination as to whether additional or subsequent assessments are needed is made at 504. If subsequent assessments are needed, the method proceeds to 510. If no subsequent assessments are needed, the method proceeds to 508.
At 510, the determined subsequent assessments are performed.
Following either 504, or 510, and therefore the completion of the necessary assessments, it is checked whether or not the system has received a request from the user related to Risk Analysis. If the check results in a determination by 512 that the RA request has been received, the method proceeds with 514. If the check results in a determination by 512 that the RA request has not been received, the method returns to 504.
At 514, the violation reports from the stored permission assessments are generated.
At 516, the generated violation reports are shared with the requesting user. In some embodiments, the generated violation reports are further stored on the target system or a remote database for historical analysis.
In some embodiments, the assessment reports, which are automatically generated, can be used to generate predictive analysis for the user's consideration. The predictive analysis further accesses reviews the stored assessment reports, which are based on the delta changes, and implements analysis regarding violation trends and mitigation analysis over a user-selected period of time.
The generated violation report is notably still provided to the user at runtime. Within the reporting framework, the reporting mechanism is uniform for any number of users. The reporting framework is further trigger based, as described in the foregoing. The trigger used to generate the violation report is distinct from the trigger used to initiate the permission assessment engine. In some embodiments, an administrator of the target system can alter what circumstances influence, and the timing of, the trigger that results in the generation of the violation report.
In some embodiments, rules are provided as part of an out of the box ready conceptualization of the permission assessment engine and the reporting engine. For example, the system includes, pre-loaded access rules, exception access rules, critical access rules, and user assignment information. In some embodiment, a user determines which of the available rules provided as part of the out of the box product are to be implemented by selection or de-selection of the rules. Selection or de-selection of the rules could be set up during an installation wizard routine or at any point during the utilization of the product. In models in which the rules are already provided, in some embodiments, the user is provided with the option to add or delete rules for personalization of the rules.
It should be appreciated that the present invention can be implemented in numerous ways, including as a process, an apparatus, a system, a computer processor executing software instructions, or a computer readable medium such as a non-transitory computer readable storage medium, or a computer Network wherein program instructions are sent over optical or electronic communication or non-transitory links. It should be noted that the order of the steps of disclosed processes can be altered within the scope of the invention, as noted in the appended claims and in the description herein.
Although the foregoing invention has been described in some detail for purposes of clarity of understanding, it will be apparent that certain changes and modifications can be practiced within the scope of the appended claims. The present invention can be practiced according to the claims and/or the embodiments without some or all of these specific details. Portions of the embodiments described herein can be used with or without each other and can be practiced in conjunction with a subset of all of the described embodiments. For the purpose of clarity, technical material that is known in the technical fields related to the invention has not been described in detail so that the present invention is not unnecessarily obscured.
It should be noted that there are many alternative ways of implementing both the process and apparatus of the present invention. Accordingly, the present embodiments are to be considered as illustrative and not restrictive, and the invention is not to be limited to the details given herein, but can be modified within the scope and equivalents of the appended claims.
Number | Name | Date | Kind |
---|---|---|---|
6289462 | McNabb | Sep 2001 | B1 |
20110167483 | Lee | Jul 2011 | A1 |
20110277017 | Ivanov | Nov 2011 | A1 |
20130159049 | Arumugam | Jun 2013 | A1 |
Number | Date | Country | |
---|---|---|---|
20170163651 A1 | Jun 2017 | US |