Oracle EE DB Local Oracle User Necessity
I notice that out of the box Oracle EE 19c installs a local Linux user oracle and a group named oinstall of which this user is a member. This user is also a member of the dba group and hence has OS auth capability as SYSDBA. All the file ownership/group permissions of the oracle installation are set to this user/group pair.
Now our DBAs are insisting that when upgrading Oracle they need to logon/su into this oracle user account. Our Security team are questioning why they need to do this? Our security team are proposing that since our RHEL 7 machines are Active Directory joined we simply grant file permissions to the AD users to access the oracle binaries and grant logon as SYSDBA to these domain users also to do this work. We grant the permissions using AD groups so not tied to individual users.