• Create check of Outbound Oracle Profiles for Auditors

Tuesday, October 22, 2019

​You want to create a listing of all outbound Oracle users and associated profiles for PCI auditors.

- Go to server p1tk-db01 and login to the "oracle" OS account

- Navigate to directory /export/oracle/Push_Infra

- execute script ./exec_get_instance_user_info_against_all_instances.sh

- output will be placed in file get_instance_user_info.out in the same directory

Example execution and feedback (truncated)...

=============================================

NEW FILE PUSH INFRA [p1tk-db01] [oracle] [08:45:37] [~/Push_Infra]

>./exec_get_instance_user_info_against_all_instances.sh

This is a wrapper for get_instance_user_info.sh

Results will be in get_instance_user_info.out...

Run command against pt235 at den-oltp-vip.vrli.net...

ssh -q den-oltp-vip.vrli.net /pt235/u01/app/oracle/scripts/sh/get_instance_user_info.sh pt235

Run command against pch02 at den-ch-vip.vrli.net...

ssh -q den-ch-vip.vrli.net /pch02/u01/app/oracle/scripts/sh/get_instance_user_info.sh pch02

Run command against prman02 at den-rmanprd-vip.vrli.net...

ssh -q den-rmanprd-vip.vrli.net /prman02/u01/app/rmanprd/scripts/sh/get_instance_user_info.sh prman02