Viewing or Modifying CLR (.NET) Executable Properties

Display and change the properties of a CLR external environment, including the location of the executable and the associated user.

Prerequisites
Database Version Other External Environment Privileges
SAP Sybase IQ 15.3 and 15.4

View any external environment property page – none.

Modify any external environment property – you must have DBA authority.

SAP Sybase IQ 16.0

View any external environment property page – none.

Modify any external environment property – you must have the MANAGE ANY EXTERNAL OBJECT system privilege.

Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Compiled Objects > External Environments.
  3. Select a CLR (.NET) external environment from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
  4. In the properties dialog, modify any of these:
    Option Description
    Location The path to the .NET executable.
    User The SAP Sybase IQ user or role/group that the external environment uses to log in to the database. The user or role/group must have been granted DBA authority (15.x) or the MANAGE ANY EXTERNAL ENVIRONMENT system privilege (16.x).
    Comment Notes describing the external environment.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Related tasks
Authenticating a Login Account for a Managed Resource
Related reference
Other External Environment Privilege Summary