Configuring SAP Sybase IQ for Administration

To perform administration tasks, you must have the correct authority or group membership (15.3 or 15.4) or system privileges and role membership (16.0), and you may need to register the server’s Sybase Control Center agent.

1. Assign the authorities (15.3 or 16.4) or system privileges (16.0) required for administrative tasks to users who will perform those tasks. You can do this by granting the authorities or system privileges directly to user accounts or by granting the authorities or system privileges to a group or role and adding users to the group or role.
2. Register and authenticate the SCC agent associated with the SAP Sybase IQ server you want to manage.
   Note: You must register the managed server before you can register its SCC agent.

• Simplex Privilege Summary
  A list of the system privileges and object permissions required to complete the various simplex server tasks
• Multiplex Privilege Summary
  A list of the system privileges and object permissions required to complete the various multiplex server tasks
• Logical Server Privilege Summary
  A list of the system privileges and object permissions required to complete the various logical server tasks
• Logical Server Policy Privilege Summary
  A list of the system privileges and object permissions required to complete the various logical server policy tasks
• Remote Server Privilege Summary
  A list of the system privileges and object permissions required to complete the various remote server tasks
• External Login Privilege Summary
  A list of the system privileges and object permissions required to complete the various external login tasks
• Database Privilege Summary
  A list of the system privileges and object permissions required to complete the various database tasks.
• Table Privilege Summary
  A list of the system privileges and object permissions required to complete the various table tasks.
• Table Column Privilege Summary
  A list of the system privileges and object permissions required to complete the various table column tasks.
• Table Permissions Privilege Summary
  A list of the system privileges and object permissions required to complete the various table permission tasks.
• Table Constraints Privilege Summary
  A list of the system privileges and object permissions required to complete the various table constraints tasks.
• Table Index Privilege Summary
  A list of the system privileges and object permissions required to complete the various index tasks on tables.
• Table Trigger Privilege Summary
  A list of the system privileges and object permissions required to complete the various table trigger tasks on database objects.
• Table Partition Privilege Summary
  A list of the system privileges and object permissions required to complete the various table partition tasks.
• View Privilege Summary
  A list of the system privileges and object permissions required to complete the various view tasks.
• View Permissions Privilege Summary
  A list of the system privileges and object permissions required to complete the various view permission tasks.
• View Trigger Privilege Summary
  A list of the system privileges and object permissions required to complete the various view trigger tasks on database objects.
• Materialized View Privilege Summary
  A list of the system privileges and object permissions required to complete the various materialized view tasks.
• Materialized View Permissions Privilege Summary
  A list of the system privileges and object permissions required to complete the various materialized view permission tasks.
• Materialized View Index Privilege Summary
  A list of the system privileges and object permissions required to complete the various index tasks materialized views.
• Domain Privilege Summary
  A list of the system privileges and object permissions required to complete the various domain tasks.
• Text Configuration Privilege Summary
  A list of the system privileges and object permissions required to complete the various text configuration tasks.
• Text Index Privilege Summary
  A list of the system privileges and object permissions required to complete the various text index tasks.
• Sequence Generator Privilege Summary
  A list of the system privileges and object permissions required to complete the various sequence generator tasks.
• Spatial Support Privilege Summary
  A list of the system privileges and object permissions required to complete the various spatial support tasks.
• Authority-Based User Privilege Summary
  A list of the system privileges and object permissions required to complete the various authority-based user tasks.
• Authority-Based Group Privilege Summary
  A list of the system privileges and object permissions required to complete the various authority-based group tasks.
• Authority-Based Database Object Permissions Privilege Summary
  A list of the system privileges and object permissions required to complete the various authority-based user and group tasks pertaining to database objects.
• Role-Based User Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based user tasks.
• Role-Based User-Extended Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based user-extended role tasks.
• Role-Based Standalone Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based standalone role tasks.
• Role-Based Database Object Permissions Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based user, user-extended role, or standalone role tasks relating to database objects.
• Role-Based System Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based system role tasks.
• Role-Based Compatibility Role Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based compatibility role tasks.
• Role-Based System Privilege Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based system privilege tasks.
• Login Mapping Privilege Summary
  A list of the system privileges and object permissions required to complete the various login mapping tasks.
• Login Policy Privilege Summary
  A list of the system privileges and object permissions required to complete the various login policy tasks.
• LDAP Server Configuration Object Privilege Summary
  A list of the system privileges and object permissions required to complete the various LDAP server configuration object tasks for SAP Sybase IQ.
• Dbspace Privilege Summary
  A list of the system privileges and object permissions required to complete the various dbspace tasks.
• DB File Privilege Summary
  A list of the system privileges and object permissions required to complete the various DB file tasks.
• Event Privilege Summary
  A list of the system privileges and object permissions required to complete the various event tasks.
• Java External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various external environment java tasks.
• Perl External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various Perl external environment tasks.
• PHP External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various PHP external environment tasks.
• Other External Environment Privilege Summary
  A list of the system privileges and object permissions required to complete the various external environment tasks.
• Function Privilege Summary
  A list of the system privileges and object permissions required to complete the various function tasks.
• Procedure Privilege Summary
  A list of the system privileges and object permissions required to complete the various procedure tasks.
• Web Service Privilege Summary
  A list of the system privileges and object permissions required to complete the various Web service tasks.