Hi Jennifer,
Probably you will have used this feature already, if not it might be helpful. I always make use of the (CVAL(‘USERID’)) The value is the windows userid and unique in the network. Based upon this value you are able to look up the employee details in the employee table and if available he/she will have access to your application. One of the columns in the employee table is the department to which he/she belongs. The nice thing about this solution is that you don’t need any login screens and nobody is able to login using a name / password of another person. Hope it helps Tony IJntema From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: vrijdag 25 februari 2011 20:24 To: RBASE-L Mailing List Subject: [RBASE-L] - Trigger or Rule or something else? Hello, I have a form with a scrolling region displaying items listed by department. I want the users to be able to see all the items but only approve/edit those items that are listed with their department number. I have the security set up so that the application will know who the user is and their department – but how do I prevent them from approving or updating items that aren’t in their department? Should I use a before update trigger or a rule, or would there be a better way to handle this? Thank you, Jennifer Roberts Ohio Masonic Home This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected] , for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
