0 Replies Latest reply: Jan 10, 2012 11:11 PM by KEERTHY VISHWESHWARACHAR RSS

    Need data restriction help

    KEERTHY VISHWESHWARACHAR

      Hi All,

       

      I have below user table and I have attached sample reporting hierarachy. Need help to build identification code to restrict user by considering multiple data restriction fields.

       

       

       

       

      section Access;

      LOAD * INLINE [  

      ACCESS, USERID, PASSWORD,

      USER    Malinga    Coach

      USER    Odumbe    Coach

      USER    Sachin    Coach

      USER    Yosuf    Coach

      USER    Prasad    Manager

      USER    Praveen    Manager

      USER    Sunil    Manager

      USER    Srinath    SManager

      USER    Venkatesh    SManager

      ADMIN    JoyKing    Exec

      ];

       

      Reporting_Hierarchy Table:

      AgentName    CoachName    ManagerName    SManagerName    ExecName

      Vicky    Sachin    Prasad    Venkatesh    JoyKing

      Raj    Sachin    Prasad    Venkatesh    JoyKing

      Joseph    Sachin    Prasad    Venkatesh    JoyKing

      Rohit    Malinga    Sunil    Srinath    JoyKing

      Dhoni    Malinga    Sunil    Srinath    JoyKing

      Ponting    Yosuf    Sunil    Srinath    JoyKing

      Fleming    Yosuf    Sunil    Srinath    JoyKing

      Virat    Odumbe    Praveen    Venkatesh    JoyKing

       

       

      So, Ex: Prasad should be able to access Coach Sachin data and all his agents data.

      Sunil should be able to access coach Malinga and Yosuf data and all his agents data.

       

       

       

      Thanks in advance,

       

      Keerthy