Hi
The requirement is slightly different. I have a DB Table which has group names. I have to check is logged in users belogs to groups which held in db table.
Can anyone help me how to do it.
P.S Groups may have subgroups as well.
Thanks,
Raji
+5
Hi Raji,
In a high level overview, create a Stored Proc that will determine if the user has access. In the Form, use the SmartObject (on the Stored Proc) to get the result and process accordingly.
In a bit more details:
1. Create a Stored Proc that accepts the AD login name, the form ID and any other information. The output/return should indicate whether the user has access to the form.
2. Expose the Stored Proc as a SmartObject.
3. Create a common View.
a. Add a parameter "formID" that will be passed in by the Form.
b. Add a new rule that listens to the "Initialising" event and execute the SmartObject
c. If the SmartObject result is false, show a message and navigate the form to the home page (or any other forms / url)
4. Add this common View to your Forms and remember to pass in the form ID to the view on form initialising event.
JK.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.