1 Reply Latest reply on Mar 14, 2017 5:10 PM by diego.medrano

    Row level Security

    Saket Krishna

      Hi All,

       

      I have a scenario when I apply user filter on my Security table i get records as below (Attached). It is not always that we have 2 records for a user it may be 1 or 2 or 3 or more and the way they want user filter to be applied is as below. Incase if there is third records then it will have one more 'OR' condiation. If a particular column is null it means user has access on all Like DEPT_CODE (First Record).

      -----------------------------------------------------------------Considering a user has two records

      ORGID = '100' and Company = '10' and DIV_CODE = '60'

       

      OR

       

      ORGID = '200' and DIV_CODE = '70' and DEPT_CODE = '456'

      -----------------------------------------------------------------

      USERNAME   ORGID  COMPANY     DIV_CODE      DEPT_CODE

      XXX                   100          10                    60                         

      XXX                   200                                  70                    456

       

      Please let me know how address this problem.

       

      Regards

      Saket