oracle 11g fine grained auditing

Fine-grained auditing (FGA) is introduced in Oracle 9i. It can record SCN numbers and row-level changes to recreate old data,However, they can only be used for select statements, but not for DML, such as update, insert, and delete statements.Therefore, for Oracle database ve

Fine-grained auditing (FGA) is introduced in Oracle 9i. It can record SCN numbers and row-level changes to recreate old data, However, they can only be used for select statements, but not for DML, such as update, insert, and delete statements. Therefore, for Oracle databas

Fine-grained audits (FGA), introduced in Oracle 9i, can record the SCN number and row-level changes to reconstruct old data, but they can only be used for SELECT statements, not for DML, such as update, Insert and DELETE statements. Therefore, for a previous version of Oracle database 10g, using triggers is not an attr

invoked only after the first row, matches the audit condition in the query is processed. If The procedure fails with an exception, the user SQL statement would fail as well. NULL enable enables The policy if TRUE, which is the default. TRUE statement_types the SQL statement types to which This policy is applicable: INSERT , UPDATE , DELETE , or SELECT only. select audit_trail destin

Tags: using SP amp AD BS SQL type TT userExample of a Scott user's EMP table----Increase PolicyBeginDbms_fga. Add_policy (Object_schema = ' SCOTT ',object_name = ' EMP ',Policy_name = ' Mypolicy1 ',Handler_schema = NULL,Handler_module = NULL,Enable = TRUE,Statement_types = ' INSERT, Update,delete ',Audit_column_opts = Dbms_fga. Any_columns);End----Enable policyBeginDbms_fga. Enable_policy (Object_schema = ' SCOTT ',object_name = ' EMP ',Policy_name = ' Mypolicy1 ',enable = TRUE);End SELECT * fro

from Dba_fga_audit_trail;Statement_type Sql_text-------------- -----------Select SELECT * FROM T_audit_demo Note: The previous INSERT statement is not in the audit. The default is to audit only select. It captures only SELECT statements in Oracle 9i. It is extended in Oracle 10i to enable auditing of all types of DML. 6. Modify the granularity of the audit ( us

1, FGA strategy (fine-grained audit) DBMS_FGA is a package for the SYS user (1) Increase FGA strategy --Audit form GRANT Resource,connect to bank identified by bank; CREATE TABLE BANK. ACCOUNTS （ Acct_no number PRIMARY KEY, cust_id number not NULL, BALANCE number (15,2) NULL ）； INSERT into bank.accounts values (1,1,10000); INSERT into bank.accounts values (2,2,20000); Commit Begin Dbms_fga.dr

1024 C. vi /etc/pam.d/login [[Email protected] ~] # vi/etc/pam.d/login/*session required/lib/security/pam_limits.sosession required PAM_ limits.so*/ D. vi /etc/profile [[Email protected] ~] # vi/etc/profile/*"Oracle" ]; Then"/bin/ksh" ]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fifi*/ E. Configuring environment variables[Email protected] ~]# vi/home/oracle/.bash_profile/*export or