Prev
Next
Forums S3 Security

Writing rules on Table files

Sort:
You are not authorized to post a reply.
Author
Messages
RobertL
Basic Member
Posts: 17
Basic Member
6/9/2010 4:26 PM
    Anyone knows how to write conditional rule access for Currency Code table file ? This is the CUCODES table file under IF system code in the Securable Type Files.

    I have a Currency Code Form CU01.1 and want to write a rule to block user access so that they cannot add or change currency code. I set the Unconditional Access for Action to "I" for CUCODES under IF system code in the Files level (not Online), but it is not working; user can still add/change a new currency. I want to do this in the Files level, and keep the original default buttons intact.

    Thanks.

    Brian Allen
    Veteran Member
    Posts: 104
    Veteran Member
    6/9/2010 5:40 PM
      The File access is for selects (form drop downs) and drill around only. You would need to set the online to "Inquire' only. This would prevent updates from within Lawson or from the add-ins.
      RobertL
      Basic Member
      Posts: 17
      Basic Member
      6/9/2010 5:45 PM
        Besides the online, is there any other option I can use ?
        MattD
        Veteran Member
        Posts: 94
        Veteran Member
        6/10/2010 12:05 PM
          It generally needs to be written for both. Can I inquire on why you don't want to set it on the online forms? That may help come to a better solution. Cheers.
          RobertL
          Basic Member
          Posts: 17
          Basic Member
          6/10/2010 10:11 PM
            Using online forms will require a lot of work and time consuming as I am going to create a security role with a class that has Inquiry Access only to all forms. If I set up the Inquiry Access rule in the Files TBL then I can save time.
            Dave Amen
            Veteran Member
            Posts: 75
            Veteran Member
            6/10/2010 11:36 PM
              Hi Robert,
              Unfortunately, as Matt indicated, locking down access to tables won't affect access in the forms. And it takes a lot of mouse clicks to make inquiry-only screens. Here's how to do what you want:

              Grant INP in CU01.1, and exclude ACD.
              Grant full access to CUCODES.

              With access to CU01, even with NO access to the tables behind it, you can perform the allowed functions in CU01. The drill won't work and you can't use the selection list to pick a currency code, but otherwise you have all functions allowed in CU01.

              Granting access to CUCODES gives you the selection list, drill around, and you can also use the table download feature in Microsoft Add-ins (there is no table update capability).

              So, the only way to lock down access as you described is to do it in the CU01 form.
              You can safely give full access to CUCODES, though, because there is no way to make changes to that with Add-ins or Portal.

              There actually is a "shortcut" to do this using XML files, but that's rather involved. Call me if you'd like!

              Best regards,
              Dave
              (303) 773-3535
              You are not authorized to post a reply.