As DBA643, where do you find FGA audit entries (data)? Options are: (MCQ) a. DBA_AUDIT_TRAIL B. DBA_FGA_AUDIT_TRAIL C. DBA_FGA D. DBA643_FGA_AUDIT_TRAIL

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

5. As DBA643, where do you find FGA audit entries (data)?

Options are: (MCQ)

a. DBA_AUDIT_TRAIL

B. DBA_FGA_AUDIT_TRAIL

C. DBA_FGA

D. DBA643_FGA_AUDIT_TRAIL

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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Basic sql queries
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