Oracle DBA

Security & Access Control

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.

This is 5 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples