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 You must have 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
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.

Modify database options – you must have DBA authority.
SAP Sybase IQ 16.0 View database options only – none.
Modify database options – Depending on the option being modified, you must have 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 – you must have EXECUTE permission on the sp_iqlmconfig system procedure to display the content of the page.

View any other database property page – none.

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

Modify any other database property – you must have DBA authority.
SAP Sybase IQ 16.0

View database license management property page – you must have EXECUTE permission on the sp_iqlmconfig system procedure along with the SERVER OPERATOR system privilege to display the content of the page.

View any other database property page – none.

Modify the following properties on the Settings page:
  • Refresh button – you must have the SERVER OPERATOR or ALTER DATABASE system privilege.
  • Collect Information about deadlocks option – you must have the SET ANY SYSTEM OPTION system privilege.
  • Include SQL statement information option – you must have EXECUTE permission on the sa_server_option system procedure along with the SERVER OPERATOR system privilege to modify this setting.
  • Clear Deadlock Information Now option – you must have the SERVER OPERATOR system privilege.

Modify properties on the license management page – you must have the SERVER OPERATOR system privilege.
Parent topic: Databases
Related tasks
Creating a Database
Creating a Database Using a CSV File
Setting Database Options
Viewing or Modifying Database Properties