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 Requires one of:
  • DBA authority.
  • SPACE ADMIN authority.
SAP Sybase IQ 16.0 Requires MANAGE ANY DBSPACE system privilege.

Deleting a Dbspace

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

Preallocating Space for a Dbspace

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

Generating Dbspace DDL Commands

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

Changing a Dbspace to Read-Only

Database Version Dbspace Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • SPACE ADMIN authority.
SAP Sybase IQ 16.0 Requires 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 required.

Modify dbspace permissions – Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
Modify any other dbspace property – Requires one of:
  • DBA authority.
  • SPACE ADMIN authority.
SAP Sybase IQ 16.0

View any dbspace property page – None required.

Modify dbspace permissions – Requites MANAGE ANY DBSPACE system privilege.

Modify any other dbspace property – Requires MANAGE ANY DBSPACE system privilege.

Granting and Revoking Dbspace CREATE Permission

Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
SAP Sybase IQ 16.0 Requites MANAGE ANY DBSPACE system privilege.
Related tasks
Creating a Dbspace
Deleting (Dropping) a Dbspace
Preallocating Space for a Dbspace
Generating Dbspace DDL Commands
Changing a Dbspace to Read-Only
Viewing or Modifying Dbspace Properties
Granting Dbspace CREATE Permission
Revoking Dbspace CREATE Permission