PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 2/1/2012 1:03 PM by  Mike Flynn
GL45 Security
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Mike Flynn
Private
Private
Basic Member
(13 points)
Basic Member
Posts:5


Send Message:

--
1/17/2012 4:24 PM
    I have tried writing a rule on GL45 so that users can only see their own transactions (operator) equal their user id.  This denies them access to all data. 
    I did write a rule on the GLCONTROL limiting the same thing so it prevents drill around on others transactions.
    However, I don't even want them to see 'others'.  Any ideas?  I've tried (userid and employee id are the same here):
    if(form.SEL_OPERATOR==user.getEmployeeId())
       'ALL_ACCESS,'
    else
       'NO_ACCESS,'

    Also tried:

    if(getDBField('GLCONTROL','OPERATOR',form.GLC_COMPANY,form.GLC_FISCAL_YEAR,form.GLC_ACCT_PERIOD)==user.getEmployeeId())

       'ALL_ACCESS,'

    else

       'NO_ACCESS,'



    Any ideas?
    Jimmy Chiu
    System Analyst
    Federal Government
    Veteran Member
    (1880 points)
    Veteran Member
    Posts:640


    Send Message:

    --
    1/26/2012 7:32 PM
    You are comparing the wrong fields. user.getEmployeeID() will never match form.SEL_OPERATOR.

    Looking at the GLCONTROL operator value. It's actually the UID. So you need to compare user attribute lawsonuserlogin vs the GLCONTROL REL_OPERATOR.
    Mike Flynn
    Private
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    2/1/2012 1:02 PM
    In this case their user id and employee id are identical but I'll try using their login and the rel_operator. Thanks
    Mike Flynn
    Private
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    2/1/2012 1:03 PM
    In this case their user id and employee id are identical but I'll try using their login and the rel_operator. Thanks
    You are not authorized to post a reply.