Platform Deployment Guide › iConsole Standard Searches, Reports and Policies › Standard Searches, Reports and Dashboard › Requirements › Database Requirements › Primary User Requirements for Dashboard

Primary User Requirements for Dashboard

To ensure that the dashboard is correctly populated with data, your CA DataMinder primary user (or login) must be correctly configured to run data warehousing jobs. Your primary user is the account that you specify in the Database Accounts screen of the CMS installation wizard. It is the main account that CA DataMinder uses to access the CMS database.

Note: By default, the CA DataMinder primary login in is WGNUSER.

Verify that your primary database account has the required privilege or role before you install the dashboard.

Oracle CMSs

Your primary user needs the CREATE JOB privilege. To verify that your primary user has this privilege, run this command:

SELECT * FROM DBA_SYS_PRIVS WHERE PRIVILEGE ='CREATE JOB';

If you primary user does not have this privilege, run this command line as an Oracle SYS user:

GRANT CREATE JOB TO WGNUSER; COMMIT;

Note: The CREATE JOB privilege is granted automatically when you install a version 12.0 or later CMS.

SQL Server CMSs

Verify that your primary login (such as WGNUSER) has been added as a user in the msdb system database. Verify that that this user has been granted the msdb database role SQLAgentUserRole.

Note: The SQLAgentUserRole role is granted automatically when you install a version 12.0 or later CMS.

Important! Do not confuse this WGNUSER database user in the msdb system database with the WGNUSER instance-level login!