* .Scripts 예
(사용 예)
begin logging with text on each SELECT by HDSDBA on database HD01DB;
       end     logging  on SELECT by HDSDBA on database VM;

       (Logging Rule 확인 방법)
       locking row for access
       select username, databasename, tvmname ,exe, sel ,upd ,upd, del, ins
       from dbc.acclogrules;
   
       (확인방법)
        select * from dbc.accesslog where logdate = '2003-03-03';

*. 실 수행 Log
1. Begin Logging :
Logging
BTEQ 06.01.00.02 Fri Nov 22 10:58:14 2002
 
+---------+---------+---------+---------+---------+---------+---------+----
.logon dbc,

 *** Logon successfully completed.
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 1 second.
 
+---------+---------+---------+---------+---------+---------+---------+----

/*------------------------
  Begin Logging User
-------------------------*/
begin logging with text on each SELECT, EXECUTE by QRY01 on database MART;

 *** Begin logging completed.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
begin logging with text on each SELECT, EXECUTE by QRY01 on database VM;

 *** Begin logging completed.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
begin logging with text on each SELECT, EXECUTE by MSI01 on database MART;

 *** Begin logging completed.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
begin logging with text on each SELECT, EXECUTE by MSI01 on database VM;

 *** Begin logging completed.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

locking row for access
sel username (char(6)), databasename (char(6)), tvmname (char(4)),
acrexecute, acrselect ,acrupdate , acrdelete, acrinsert
    from dbc.acclogrules;

 *** Query completed. 4 rows found. 8 columns returned.
 *** Total elapsed time was 1 second.

UserName  DatabaseName  TVMName  EXE  SEL  UPD  DEL  INS
--------  ------------  -------  ---  ---  ---  ---  ---
QRY01     VM            All      E +  E +
MSI01     VM            All      E +  E +
QRY01     MART          All      E +  E +
MSI01     MART          All      E +  E +

+---------+---------+---------+---------+---------+---------+---------+----

.logoff
 *** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.quit
 *** Exiting BTEQ...
 *** RC (return code) = 0

2. End Logging
BTEQ 05.04.01.00 Fri Dec 22 13:59:27 2000
 
+---------+---------+---------+---------+---------+---------+---------+----
.logon dbc,

 *** Logon successfully completed.
 *** Transaction Semantics are BTET.
 *** Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 1 second.
 
+---------+---------+---------+---------+---------+---------+---------+----

end logging with text on
 user,database, table, view, grant on database MDW1_DB;

 *** End logging completed.
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.logoff
 *** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.quit
 *** Exiting BTEQ...
 *** RC (return code) = 0