FGAuditing Global Context Question
Hi, I don't know what type of FGA to use or how to implement it. I'm hoping someone can give me the right kind of FGA, steps and examples.
We have a Java application that uses a connection pool to connect to the Oracle database using a single schema account. So schema Scott might have 100 connections. However, each Scott db connection will be a different student that has logged in via the application. If FGA is triggered from an auditing policy, I need to know which student (logged in as Scott) made the changes.
I'm reading the "Oracle Database Security Guide (1ogR2) and think that I need to use "Global Application Context", but I'm confused on how to set the STUDENTS Name and STUDENT ID in the context. Also, how to retrieve (or read) the values for the STUDENT that triggered the audit (i.e. modified grades in the grades table).
We have a Java application that uses a connection pool to connect to the Oracle database using a single schema account. So schema Scott might have 100 connections. However, each Scott db connection will be a different student that has logged in via the application. If FGA is triggered from an auditing policy, I need to know which student (logged in as Scott) made the changes.
I'm reading the "Oracle Database Security Guide (1ogR2) and think that I need to use "Global Application Context", but I'm confused on how to set the STUDENTS Name and STUDENT ID in the context. Also, how to retrieve (or read) the values for the STUDENT that triggered the audit (i.e. modified grades in the grades table).
0