Securing the monitor model database delete schema

By default, the delete schema script contains the required grant statements if multiple versions of the model are deployed, but the statements are commented out. Grants must be issued because the cross-version views are dropped and re-created when the drop schema script runs. To implement the grant statements for greater security, uncomment the grant statements and run the monitor model delete schema script.

1. Export the delete schema script using the following steps.
2. In the WebSphere® Application Server administrative console, click Applications > Monitor Models.
3. Click the version of the model.
4. Click Manage Schema.
5. Click Export Delete Schema Script.
6. Save the file.
7. Navigate to the directory containing the exported script, which is a DDL file.
8. Edit the DeleteSchema_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 "".
9. Run the delete script using the DeleteSchema_ModelName.ddl file.
   On DB2®, in the DB2 command window, enter the following command:

   db2 -td@ -vf DeleteSchema_ModelName.ddl

   On Oracle, enter the following command:

   sqlplus dbadmin/dbpassword@orcl @DeleteSchema_ModelName.ddl

   On Microsoft SQL Server, enter the following command:

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

   where

   ModelName is the name of the model.