Prev
Next
Forums S3 Security

ESS LS

Sort:
You are not authorized to post a reply.
Author
Messages
KB
Posts: 23
7/6/2011 12:59 PM
    We are troubleshooting our ESS LS rule and are having a problem with a DME call.  On the table we have tried to secure we have a conditional rule as follows...

    if(user.getEmployeeId()==table.EMPLOYEE)
       'I,'
    else
       'NO_ACCESS,'

    We are trying to lock the table down so they can only see their own data. 

    A DME call against this same data returns 0 results. 

    Shouldn't this rule work? 
    Al
    Basic Member
    Posts: 17
    Basic Member
    7/6/2011 1:22 PM
      You will need to use lztrim function. Example of our rule in ESS is:

      if(lztrim(table.COMPANY)==user.getCompany()&&lztrim(table.EMPLOYEE)==user.getEmployeeId())
      Al
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      7/6/2011 2:01 PM
        This is the rule I would use (note the lztrim as well as checking the RM access flag for selected users to bypass this rule):
        if(user.getCompany()==lztrim(table.COMPANY)&&user.getEmployeeId()==lztrim(table.EMPLOYEE) || user.getAttribute('Access')=='Y')
        'I,'
        else
        'NO_ACCESS,'
        Thanks for using the LawsonGuru.com forums!
        John
        You are not authorized to post a reply.