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