Database Privilege Summary

A list of the system privileges and object permissions required to complete the various database tasks.

Creating a Database

Database Version Database Privileges
SAP Sybase IQ 15.3 and 15.4 Required DBA authority. The account under which the server is running must have write permissions on the directories where files are created.
SAP Sybase IQ 16.0 The account under which the server is running must have write permissions on the directories where files are created. No other system privilege is required.

Creating a Database Using CSV File

Database Version Database Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 The account under which the server is running must have write permissions on the directories where files are created. No other system privilege is required.

Setting Database Options

Database Version Database Privileges
SAP Sybase IQ 15.3 and 15.4

View database options only – None required.

Modify database options – Requires DBA authority.
SAP Sybase IQ 16.0 View database options only – None required.
Modify database options – Depending on the option being modified, requires one of:
  • SET ANY PUBLIC OPTION system privilege.
  • SET ANY SECURITY OPTION system privilege.
  • SET ANY SYSTEM OPTION system privilege.

Viewing or Modifying Database Properties

Database Version Database Privileges
SAP Sybase IQ 15.3 and 15.4

View database license management property page – Requires EXECUTE permission on the sp_iqlmconfig system procedure to display content of page.

View any other database property page – None required.

Modify the following properties on the Settings page requires:
  • Include SQL statement information option – Requires EXECUTE permission on the sa_server_option system procedure to modify this setting.
  • Collect Information about deadlocks option – Requires DBA authority.
  • Clear Deadlock Information Now option – Requires DBA authority.

Modify any other database property – Requires DBA authority.
SAP Sybase IQ 16.0
View database license management property page –
  • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sp_iqlmconfig system procedure to display content of page.
  • If the system procedure security model* of the selected database is set to Invoker, you require the SERVER OPERATOR system privilege to display content of page.

View any other database property page – None required.

Modify the following properties on the Settings page requires:
  • Refresh button – Requires SERVER OPERATOR or ALTER DATABASE system privilege.
  • Collect Information about deadlocks option – Requires SET ANY SYSTEM OPTION system privilege.
  • Include SQL statement information option –
    • If the system procedure security model* of the selected database is set to Definer, you require EXECUTE permission on the sa_server_option system procedure to modify this setting.
    • If the system procedure security model* of the selected database is set to Invoker, you require the SERVER OPERATOR system privilege to display content of page.
  • Clear Deadlock Information Now option – Requires SERVER OPERATOR system privilege.
Modify properties on the license management page –
  • Requires SERVER OPERATOR system privilege.
*The system procedure security model of the selected database appears on the General page of database properties.
Parent topic: Configuring SAP Sybase IQ for Administration
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group