1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Security Profile -Custome Security

Discussion in 'Oracle HRMS & Payroll' started by ilush, Dec 28, 2011.

  1. ilush

    ilush Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I need to enter SQL to tab Custome Security in Security Profile that will bring to the result:
    Show only people with Location=XYZ (no other limitation such as BU, ORG etc.)
    1.What is the correct SQL?
    2. At the head of the screen- Should I restrict View Empl, CWK etc. ?

    Thanks,
    Ilanit