CampaignMax Database Update Utility fails with ORA-01720 and/or ORA-01031

Problem Description

When using the Oracle IMP (Import) utility to import a database from a DMP file, the recommended procedure is to run the CampaignMax Database Update Utility after running IMP.  Unfortunately, Oracle has made subtle changes to their security model that cause the utility to fail.  The utility may give the following errors while running:

SYSTEM: Grant Select on camRoles to CAMPMGR...Failed with this Error:
   ORA-01720: grant option does not exist for 'SYS.DBA_ROLES' (0x80004005)

SYSTEM: Grant Select on camUsers to CAMPMGR...Failed with this Error:
   ORA-01720: grant option does not exist for 'SYS.DBA_USERS' (0x80004005)

SYSTEM: Grant Select on camRolePrivs to CAMPMGR...Failed with this Error:
   ORA-01720: grant option does not exist for 'SYS.DBA_ROLE_PRIVS' (0x80004005)

CAMPMGR: Creating View camNamesOnlyV...Failed with this Error:
   ORA-01031: insufficient privileges (0x80040E09)

Problem Resolution

Perform the following steps on the machine that has the Oracle database installed on it:

1. Launch a command window by running: CMD.EXE
2. Launch SQL Plus command line by running: SQLPLUS / AS SYSDBA
3. Run the following commands at the SQL Command line.  Each command should respond with "Grant successful".
   1. grant select on sys.dba_roles to system with grant option;
   2. grant select on sys.dba_users to system with grant option;
   3. grant select on sys.dba_role_privs to system with grant option;
   4. grant create view to CAMPMGR;  
4. At this point, the CampaignMax Database Update Utility should run successfully.