Policy Violation
874555Jul 14 2011 — edited Dec 27 2011Hello,
My Database version is 11.2.0.2.2
In Enterprise manager , I have the following alert
"Ensures that one user does not have EXECUTE and READ/WRITE privileges on the same directory object"
I have seen that one of the DBA have created a directory object with a user having a DBA role; In his object creation he only executed:
"CREATE OR REPLACE DIRECTORY CLASS_DIR AS '/tmp/class_ioy/' ; "
He didn't grant nor execute nor read/write !
My questions are:
1- How to solve this issue?
2- What are the impacts of having a user execute and read/write premission on the same directory object?