Required O/S Permissions on database files
Hi,
We are running EBS 11.5.10.2 on an 11.2.0.4 database on Solaris SPARC 10, in a distributed environment, meaning the application and database are on separate servers.
The file permissions of our database files (*.dbf) is "-rw-r----- 1 oracle dba", meaning that the owner (oracle) has read/write permissions on the file, and the group (dba) has read permisisons on the file. The group (dba) only has 2 users in it (oracle and applmgr).
An audit finding has been raised that there are excessive permissions on the database files, and that we should ensure that "group" and "world" do not have permissions to the database files. When we attempted to implement this change on a test environment (only granted owner rw permisisons to the files), we were unable to start and use the EBS Application.