Record and backup all addition, deletion, modification, and deletion operations of users

Installation instructions 1. decompress the package to a local disk. 2. Open the install. SQL file and change the parameters such as the logon username, password, and log file storage path according to the prompt text in the file. 3. Use Sqlplus to run the install. SQL file and perform the installation. Instructions for use 1. The log administrator must first fill in the FLOG. LOG_USER table

Installation instructions 1. decompress the package to a local disk. 2. Open the install. SQL file and change the parameters such as the logon username, password, and log file storage path according to the prompt text in the file. 3. Use Sqlplus to run the install. SQL file and perform the installation. Instructions for use 1. The log administrator must first fill in the FLOG. LOG_USER table

Installation instructions
1. decompress the package to a local disk.

2. Open the install. SQL file and change the parameters such as the logon username, password, and log file storage path according to the prompt text in the file.

3. Use Sqlplus to run the install. SQL file and perform the installation.


Instructions for use
1. First, the log administrator must enter the Logon account and password in the FLOG. LOG_USER table.

2. After establishing a database connection, first execute the Stored Procedure LOGON to record the login information.
For how to use the Stored Procedure LOGON, see Sample. SQL.

3. If Logon is not executed or Logon fails, you cannot add data in the data table in this session,
Modify and delete operations, but query operations can be performed.

Administrator user guide
1. View V_LOG_OPERATE to query the user's logon/logout history,
You can also find the rows in which tables (expressed in ROWID) You performed during login.

2. View V_LOG_DETAIL to query the old data affected by the UPDATE and DELETE operations.

3. If the user updates or deletes large object data (BLOB, CLOB, etc ),
Search for the operated data in the V_LOG_BLOB, V_LOG_CLOB, V_LOG_GEOM, and V_LOG_BFILE views.

The Code was written at Oracle 9i. Now the Oracle version is 12c and there is no need to keep it confidential.
<无>

-- Used to demonstrate how the FLOG system uses the sample data -- Code by www.ultragis.com -- connect FLOG/FLOG -- to create a business user insert into FLOG. LOG_USER (USERNAME, PASSWORD) values ('dt', 'dt'); -- connect WS/WSset serveroutput onvar v_accredit NUMBER; -- business user logon begin: v_accredit: = 0; LOGON ('dt', 'dt',: v_accredit); if (: v_accredit = 0) then dbms_output.put_line ('login failed! '); Else dbms_output.put_line (' logon successful! '); End if; exception when others then dbms_output.put_line (to_char (SQLCODE) |': '| SQLERRM); end;/commit; select: v_accredit from dual; -- after successful logon, Insert, Update, and Delete operations can be performed. -- If logon fails, Select operations can only be performed.