I wonder if this is something that might be accomplished using row-level security and the assignee groups field 112. J.T. Shyman Column Technologies <mailto:[EMAIL PROTECTED]>
________________________________ From: [EMAIL PROTECTED] on behalf of Joel Sender Sent: Fri 11/30/2007 4:08 PM To: [email protected] Subject: RE: Preventing "Public" from running queries Dwayne, The idea is to check group membership when a window is opened in 'Search' mode. For example: On Form B, create an Active Link that executes 'On Open' with a Run-if $OPERATION$ != "Display" AND $GROUP$ = "Public" Then 1. Open Window, Display, where $Entry_ID$ = $LASTID$ 2. Close Window (DO NOT select 'Close All Windows') OR just issue an error message & close the window. Note that you may need to tweak the Run-if to capture the correct users. Also, the 'Close Window' follows the 'Open Window' action, which may be confusing: just remember you're closing the first window AFTER you open the second. HTH, Joel ************************* Joel D. Sender Director of Western Operations QMX Support Services, Inc. [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Friday, November 30, 2007 11:27 AM To: [email protected] Subject: Preventing "Public" from running queries Hello Everyone, We have a main Form A, and a subfile Form B. The assignee in Form B can click a button, which will call an Active Link, which will open the parent Form A. If the user has only "Public" permissions we do NOT want herm (her/him) to launch a general query and see other Form A records. BUT we want users who DO have write permissions to Form A to be able to launch a general query and see other Form A records. If I disable the "New Searches" button, our users with write permissions won't be able to launch queries. I tried using an active link to check the user's permissions, and send an error message if heesh doesn't have any. The trouble is, when you do an "Open Window" action to display a selection of records, the link first does a search, so whether the link fires on "Window Open", "Search", or "Window Loaded" it fires before displaying the records and the user doesn't even get to see the records you DO want herm to see. Any suggestions? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
