Cisco Cisco Workload Automation 6.3 User Guide

Configuring the JDBC Adapter

Securing the JDBC Adapter

Schedulers are those users who will define or manage JDBC jobs and events. There are three aspects of a user 
profile that grant or limit access to scheduling jobs that interact with JDBC:

Security policy that grants or denies add, edit, delete, and view capabilities for JDBC jobs and events.

Authorized runtime user list that grants or denies access to specific database user accounts for use with 
database connections to run SQL commands, scripts, and stored procedures.

Authorized agent list that grants or denies access to specific JDBC adapter connections for use when defining 
JDBC jobs and events.

Defining Runtime Users (Database Users)

From the 

 pane, select 

 to display the defined users in the 

 

pane.

Right-click and select 

from the context menu, or select an existing user and choose 

 to 

display the 

 dialog.

If this is a new user definition, enter the new user name in the 

 field.

For documentation, enter the 

 or description associated with this user.

In the 

 field, select a Windows domain associated with the user account required for authentication, if 

necessary.

On the 

 tab, click 

 to display the 

 dialog.

From the 

 list, select 

.

Enter a password (along with confirmation) in the 

and

fields.

Only those users with a password specified for JDBC will be available for use with JDBC jobs and events. The 
password may be the same as the one specified for Windows/FTP jobs.

Click 

 on the 

 dialog.

The

 dialog displays the new record.

Click 

 to add or save the user record in the CWA database.

Authorizing Schedulers to Work With JDBC Jobs and Events

Authorizing schedulers to work with JDBC jobs and events requires:





Defining a JDBC Security Policy

To define a Security Policy that authorizes access to JDBC jobs and events, select 

from the 

 pane to display the 

pane, listing all defined users.