When running the CampaignMax Database Utilities under Oracle 8.1.7, you may get one of these following errors:

Under Oracle 8i:
ORA-01720 grant option does not exist for 'SYS.DBA_ROLES'
Under Oracle 9i:
ORA-01031: insufficient privileges (0x80040E09)

This occurs because Oracle removed some rights from the SYSTEM user in either v8.1.6 or 8.1.7. To restore those rights, do the following:

1. Start SQL*Plus
2. Connect to the database as the SYSTEM user (default password is manager). The command should look like this:
CONNECT system/manager
3. Issue the following SQL command:
GRANT SELECT ANY DICTIONARY
TO system;

******************************************************
*********** These instructions were replaced by those listed above on 9/10/2002. The instructions above have only been tested on Oracle 9i.
******************************************************
1. Start SQL*Plus
2. Connect to the database as the SYS user (default password is change_on_install). The command should look like this:
CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
3. Issue the following SQL command:
GRANT ALL
ON dba_roles
TO system WITH GRANT OPTION;
4. Issue the following SQL command:
GRANT ALL
ON dba_users
TO system WITH GRANT OPTION;
5. Issue the following SQL command:
GRANT ALL
ON dba_role_privs
TO system WITH GRANT OPTION;

*****************************************
This problem has been fixed in CampaignMax v3.0