Dbspace Privilege Summary

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

Creating a Dbspace

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY DBSPACE system privilege.

Deleting a Dbspace

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY DBSPACE system privilege.

Preallocating Space for a Dbspace

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY DBSPACE system privilege.

Generating Dbspace DDL Commands

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 None
SAP Sybase IQ 16.0 None

Changing a Dbspace to Read-Only

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY DBSPACE system privilege.

Viewing or Modifying Dbspace Properties

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4

View any dbspace property page – none.

Modify dbspace permissions – You must have one of:
  • DBA authority
  • PERMS ADMIN authority
Modify any other dbspace property – you must have one of:
  • DBA authority
  • SPACE ADMIN authority
SAP Sybase IQ 16.0

View any dbspace property page – none.

Modify dbspace permissions – You must have the MANAGE ANY DBSPACE system privilege.

Modify any other dbspace property – you must have the MANAGE ANY DBSPACE system privilege.

Granting and Revoking Dbspace CREATE Permission

Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • PERMS ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY DBSPACE system privilege.
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