The files in the SESAM/SQL database (database files, database-specific files, and DBH-specific files) are ordinary files that can be password-protected from the point of view of BS2000. The database administrator can assign a BS2000 password in the utility statement CREATE CATALOG when creating a database. SESAM/SQL automatically applies this password to all files in the database.
If the database is to be created under a DB user ID, the database administrator must declare the DBH user ID in the DB user ID as a co-owner of the files concerned or create the files and assign the BS2000 password him or herself, see section “Database files and job variables on foreign user IDs”. The password must be specified in the CREATE CATALOG utility statement.
Before they can work with a SESAM/SQL database protected by BS2000 passwords, system administrators must specify the relevant password in the DBH statement ADD-SQL-DATABASE-CATALOG-LIST when starting DBH. The password is then stored in DBH's SQL database catalog.
If the password for a SESAM/SQL database is to be changed, the database administrator must change it specifically for each individual file in the database with the aid of the command MODIFY-FILE-ATTRIBUTES. When doing this, care must be taken to ensure that the same password is assigned to each file.
If the database's password has been changed since a specific SESAM backup copy was created, the password that was valid when the SESAM backup copy was created has to be specified when the SESAM backup copy is recovered with the utility statement RECOVER.