Securing the monitor model database create schema

By default, the create schema script contain the required grant statements for securing the monitor model database, but the grant statements are commented out. For greater security, you can uncomment the grant statements and run the monitor model create schema script.

1. On the Install New Applications page, under Database options, clear the Run script to create schema check box .
2. After you install the model, export the create schema script using the following steps.
3. In the WebSphere® Application Server administrative console, click Applications > Monitor Models.
4. Click the version of the model from which you want to export the create schema.
5. Click Manage Schema.
6. Click Export Create Schema Script.
7. Save the file.
8. Navigate to the directory that contains the exported script, which is a DDL file.
9. Edit the CreateSchema_ModelName.ddl file, removing the comment indicators for each GRANT statement and allowing the statements to be implemented in the next step by replacing the string "--GRANT STMT--" with "".
10. Run the create script using the CreateSchema_ModelName.ddl file.
    On DB2®, in the DB2 command window, enter the following command:

    db2 -td@ -vf CreateSchema_ModelName.ddl

    On Oracle, enter the following command:

    sqlplus dbadmin/dbpassword@orcl @CreateSchema_ModelName.ddl

    On Microsoft SQL Server, enter the following command:

    sqlcmd -U <userid> -P <password> -e -i CreateSchema_ModelName.ddl

    where

    ModelName is the name of the model.

11. Stop and start the monitor model so that the monitor model application picks up the new database tables.