Question
System privileges versus object privileges: how should application grants be chosen?
Answer
System privileges authorize a type of action, such as CREATE SESSION or CREATE TABLE. Object privileges authorize actions on one named object. Give applications object privileges for data access, plus only the narrow system privileges needed, typically CREATE SESSION. Avoid ANY privileges. Applies to all Oracle Database editions.