Hi ARSlist users, *BackGround*: Have a Prod app and Rpt server. SQL level replication is enabled to replicate data b/w the 2 in real time. ARADMIN access is disabled on RPT to avoid users updating records.
*Issue:* Users are performing free text searches on Notes field, Resolution and summary field of Incident Form leading to timeout errors. *Proposed solution:* Plan is to provide a button on Prod Incident form. By pressing this button, Active Link will fire and open incident FORM on Reporting, where users can perform adv searches. This will work only if user have same access in both Prod and RPT. *Road Block*: Since data is getting replcated from Prod to Rpt, so users permissions also get replicated from Prod to RPT. Now each access is connected to server license so the permission replicated to Reporting is connected to Prod server and reporting server license. As a result even though user have admin access in Prod, it will work as Read only account on Reporting. (ARADMIN is locked on RPT and needs a CRQ to remove this lock for even account that needs to be udpated on Rpt). If there is a RUN Process command that can be used in AL so we can pass a authentication, then i can hard code a generic account (which has all needed ITSM access) and that should do the trick. Any help is appreciated. Alternate solutions are also welcome. Regards, Kumar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"