Using Oracle SQL Plus, login as the CMMS schema owner (usually MAXIMO), and execute the PL/SQL Script MAX411_SCRIPTS.SQL. If installing from the CD, the script files will be located in the Scripts subdirectory. If installing using the downloaded zip file from the web, the scripts will reside in the target directory used during file extraction. For the following example, we will assume we have extracted all of the script files to the C:\temp\scripts directory. So, the SQL Plus screen will look like the following after logging in and entering at the SQL prompt the shortcut command to execute the max411_scripts.sql file:

The max411_scripts.sql file will, in turn, execute the following list of scripts in the order they are listed:

If needed, the scripts can be executed individually. The only condition is that the dsutility.plsql script has been successfully compiled into the database and that workorder2.plsql follows workorder1.plsql.

Example:

        SQL> connect {schema_owner}/{schema_owner_password}@{oracle_tns};
        SQL> start {directory_path}\dsutility.plsql;

Where {directory_path} is the actual directory path to the dsutility.plsql file, such as C:\Temp\Scripts.

After the dsusers.plsql script has successfully run, grant the DS_USER role to the desired set of CMMS users.

Example:

        SQL> GRANT DS_USER to CMMS_USER1;

See the dsusers.plsql script for an example SQL query for generating a script file of GRANT statements using the SPOOL option.