Forums S3 Security

AP90 Security

Author
Messages
Sandra Badini
New Member
Posts: 3
New Member
1/14/2013 8:08 PM
    I am trying to limit AP90 security to PO Vendors only.  I tried the following rule on the AP tables used by AP90 without success.  Has anyone tried to create this type of security rule before?

    table.VENDOR == getDBField('POVENDOR','VENDOR',table.VENDOR_GROUP, table.VENDOR)
    Georgette
    Veteran Member
    Posts: 52
    Veteran Member
    2/19/2013 3:55 PM
      I am new, but I was told to use the trim function when accessing tables. Trim is for alpha numeric and lztrim for leading zeroes. So check what the data type is.

      trim(getDBField(.....)) == trim(table. ____)
      ---