Welcome, Guest! Log In | Create Account

Scripts

A script is a text file containing commands in the same form as used by Browse. Use the browse command run fileName to execute a script. Browse then passes the script to the COODBMS server which executes it as a single transaction. If there is an error while the script is being executed, the transaction aborts and the database is restored to the state it had prior to executing the script.

Scripts can also be run using the runScript databaseName branchName fileName utility. This could be handy when maintaining multiple branches under the same server.

The following commands can be used in a script file:

Script Files Included in the COODBMS Zip File

Script files have been included in the download in the client directory: secureMaster.txt and secureBranch.txt. These are covered below.

Securing the Master Database

Two things can be done to secure the master database: (1) block the use of the createMyMasterAccount command by a guest and (2) block queries by guests. This can be done by the browser command run secureMaster.txt, which executes the following sequence of commands:

go /OPERATION_GROUPS/GuestOperations
removeChild createMyMasterAccount
go /USER_GROUPS/GuestGroup/CU/OperationGroups
remove #2

Securing Branches in Other Databases

Three things can be done to secure branches in other databases: (1) block the use of the CreateMyAccount by known guests, (2) block queries by guests and (3) block queries by known users. This can be done by the browser command run secureBranch.txt, which executes the following sequence of comands:

go /OPERATION_GROUPS/KnownGuestOperations
removeChild createMyAccount
go /USER_GROUPS/GuestGroup/CU/OperationGroups
remove #2
go /USER_GROUPS/KnownGuestGroup/CU/OperationGroups
remove #3