Under what circumstances will the action(s) be audited?

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 14MC: A unique identifier for a data row that consists of more than one field is commonly called...
icon
Related questions
Question

2. Under what circumstances will the action(s) be audited?

You are given the following information:
Employee
Emp_SSN Emp_Lname Emp_Salary
Dep_Num Emp_Sex
EXEC DBMS_FGA.ADD_POLICY(object_Schema => 'Dba643', -
object_name => 'Employee', -
policy_name => 'Emp_Audit_Policy', -
audit_column => 'Emp_SSN, Emp_Salary', -
audit_condition => 'Emp_Salary >= 50000', -
audit_column_opts => DBMS_FGA.ALL_COLUMNS,-
statement_types => 'SELECT');
Answer the following
Emp_City Emp_State
Transcribed Image Text:You are given the following information: Employee Emp_SSN Emp_Lname Emp_Salary Dep_Num Emp_Sex EXEC DBMS_FGA.ADD_POLICY(object_Schema => 'Dba643', - object_name => 'Employee', - policy_name => 'Emp_Audit_Policy', - audit_column => 'Emp_SSN, Emp_Salary', - audit_condition => 'Emp_Salary >= 50000', - audit_column_opts => DBMS_FGA.ALL_COLUMNS,- statement_types => 'SELECT'); Answer the following Emp_City Emp_State
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning