0 Replies Latest reply on Oct 11, 2018 8:00 AM by PraveenKumar R-Oracle

    Web Catalogue permission changed

    PraveenKumar R-Oracle

      We are looking for a issue reported by customer that they noticed some catalogue files permissons are modified, and want to know who has done the changes.

      We see that on Sep 19th users are logged on to the system

      A308430  pts/0        10.7.96.150      Wed Sep 19 12:18 - 14:20  (02:01)
      A308430  pts/0        10.7.96.150      Wed Sep 19 09:41 - 11:11  (01:30)
      sbpadm13 pts/0        occn-pilot3.orac Wed Sep 19 04:27 - 09:10  (04:43)

      1.Folder permissions

      /shared/ADM_Webi_delivery
      /shared/BI Usage and Monitoring
      /shared/BO to OBIEE Migration
      /shared/EU Oilseeds
      /shared/Performance Reports
      /shared/Golden Peanut/


      [root@ldcxyp01-vmp2 shared]# ls -lc | grep -i ADM_Webi_delivery
      drwxr-x---  26 sbpadm13 sbpadm13  4096 Sep 19 03:10 adm_webi_delivery
      -rw-r-----   1 sbpadm13 sbpadm13   730 Sep 19 03:10 adm_webi_delivery.atr
      [root@ldcxyp01-vmp2 shared]#

      drwxr-x---  26 sbpadm13 sbpadm13  4096 Sep 19 03:10 adm_webi_delivery
      drwx------   6 sbpadm13 sbpadm13  4096 Sep 20 18:12 bi+usage+and+monitoring
      drwxr-x---  36 sbpadm13 sbpadm13  4096 Sep 20 18:15 bo+to+obiee+migration
      drwxr-x---  15 sbpadm13 sbpadm13  4096 Sep 20 18:09 eu+oilseeds
      drwx------   3 sbpadm13 sbpadm13  4096 Sep 19 03:10 performance+reports
      drwxr-x---  12 sbpadm13 sbpadm13  4096 Sep 20 17:18 golden+peanut




      We have also verified "history" command to see if there is any chmod for OS user a/c A308430

      history output shows like this for chmod


      186  chmod 777 /home/A308430/ADM_DW_V30.7_051517_fixed_v2_BI0055.rpd
      269  chmod 777 /home/A308430/ADM_DW_V30.7_051517_fixed_v2_BI0055.rpd
      375  chmod 777 /home/A308430/ADM_DW_V30.8_080117_BI0061.rpd
      412  chmod 777 /home/A308430/ADM_DW_V30.8_080117_BI0061.rpd
      414  chmod 777 /home/A308430/ADM_DW_V30.8_080117_BI0061.rpd
      646  chmod 777 /home/A308430/ADM_DW_V30.9_BI0070.rpd
      648  chmod 777 /home/A308430/ADM_DW_V30.9_BI0070.rpd
      650  chmod 777 /home/A308430/ADM_DW_V30.9_BI0071.rpd
      656  chmod 777 /home/A308430/NON_1ADM_OCT_10132017_BI0072.rpd
      662  chmod 777 /home/A308430/NON_1ADM_OCT_10132017_BI0072.rpd
      814  chmod 777 /home/A308430/NON_1ADM_OCT_10132017_BI0073.rpd
      828  chmod 777 /home/A308430/Prod_DST_PATCHED_4_4_2018_4PM_BI0076.rpd
      830  chmod 777 /home/A308430/Prod_DST_PATCHED_4_4_2018_4PM.rpd
      836  chmod 777 /home/A308430/nqserver.log
      847  chmod 777 /home/A308430/opmn.log
      862  chmod 777 /home/A308430/nqquery.log
      877  chmod 777 /home/A308430/instanceconfig.xml
      1000  history | grep -i chmo

      For OS user a/c sbpadm13  old history o/p sbpadm13


      [sbpadm13@ldcxyp01-vmp2] history | grep -i chmo
      116  chmod 777 june21_logs.zip
      205  chmod 777 instanceconfig.xml
      285  chmod -R 777 3-887NC70
      385  chmod -R 777 3-88CKQZR
      566  chmod 777 software
      660  chmod -
      661  chmod -R 777 3-887NC70
      713  chmod 777 DST_PATCHED_20180821.rpd
      997  history | grep "chmod"
      1000  history | grep -i chmo
      [sbpadm13@ldcxyp01-vmp2]





      As per the Excel sheet file permissions are updated by the Modifier "System Account " on Modified on "9/19/2018 3:10