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: arslist@ARSLIST.ORG
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: arslist@ARSLIST.ORG
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"
