C-LANG Statements › USER_TYPE Statement—Specify the Oracle Database User Type

USER_TYPE Statement—Specify the Oracle Database User Type

The USER_TYPE statement specifies the Oracle database user type. If you omit this statement from the job definition, the job runs with normal privileges.

Supported Job Types

This statement is optional for the following job types when an Oracle database is used:

• Database Monitor
• Database Stored Procedure
• Database Trigger
• SQL

Syntax

This statement has the following format:

USER_TYPE type

type

Specifies the type of Oracle user to log in as. The user must be defined in the Oracle database.

Limits: Up to 128 characters; case-sensitive

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• In Oracle, a user with sufficient authority can log in with different system privileges. For example, if a job requires sysdba privileges, enter as sysdba in this statement.
• Your agent administrator can specify a default user type for all database jobs by setting the db.default.userType parameter in the agent's agentparm.txt file.
• The USER_TYPE statement overrides the default user type specified in the agent's agentparm.txt.
• USERTYPE is an alias of USER_TYPE.

Example: Specify a Database User Type

This example specifies a database user named dbuser1, who is logged in with sysdba privileges.

AGENT CYBDB1
USER dbuser1
USER_TYPE 'as sysdba'
SQL 'SELECT * from NEWORDS'