Abstract: In one embodiment, a method replicates data from a first database system to a second database system and determines a modeling of a first access context for a table in the replicated data. An ACL rule based on the first access context is generated to restrict access to the replicated data in the second database system to users associated with the first access context. The method receives a request to access the replicated data from a user and determines a second access context for the user. The first access context for the ACL rule and the second access context for the user are compared to determine whether the user is allowed to access the replicated data. Access to the replicated data is allowed when the second access context and the first access context indicate the user is allowed to access the replicated data.

Abstract: In one embodiment, a method replicates data from a first database system to a second database system. A trigger table associated with the first database system is determined. The trigger table includes information for rows in tables of the first database system relevant to authorizations in the first database system. The method generates an access control list (ACL) report from the trigger table. The ACL report includes information for setting ACL rules for the second database system. An access context is determined for an entity from the ACL report. The method then generates an ACL rule based on the access context to restrict access to the replicated data in the second database system to users associated with the access context.

Abstract: In one embodiment, a method replicates data from a first database system to a second database system. A trigger table associated with the first database system is determined. The trigger table includes information for rows in tables of the first database system relevant to authorizations in the first database system. The method generates an access control list (ACL) report from the trigger table. The ACL report includes information for setting ACL rules for the second database system. An access context is determined for an entity from the ACL report. The method then generates an ACL rule based on the access context to restrict access to the replicated data in the second database system to users associated with the access context.

Abstract: In one embodiment, a method replicates data from a first database system to a second database system and determines a modeling of a first access context for a table in the replicated data. An ACL rule based on the first access context is generated to restrict access to the replicated data in the second database system to users associated with the first access context. The method receives a request to access the replicated data from a user and determines a second access context for the user. The first access context for the ACL rule and the second access context for the user are compared to determine whether the user is allowed to access the replicated data. Access to the replicated data is allowed when the second access context and the first access context indicate the user is allowed to access the replicated data.

Abstract: The present invention provides a system and method for providing customer relationship management by tracking customer interactions. Customer interactions include contact with customers using asynchronous communications such as e-mail, short message service (SMS) text messages from mobile phones, letters and FAXes. The system and method of the present invention include an interaction object for representing customer contact. Interaction objects are generated and stored in contact tracking storage for data that comprises details about customer contact. The interaction object is kept as an independent object outside of order object generating software. The interaction object may also be integrated with customer relationship management application software such as software used for account management.