Table Partition Privilege Summary

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

Creating a Hash Partition

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
SAP Sybase IQ 16.0 Requires one of the following:
  • ALTER ANY OBJECT system privilege.
  • CREATE permission on the dbspace along with one of:
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the table.
    • You own the table.

Creating a Range Partition

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • CREATE permission on the dbspaces where the partitions are being created.

Also requires one of:

  • ALTER permission on the table.
  • You own the table.
SAP Sybase IQ 16.0 Requires one of the following:
  • ALTER ANY OBJECT system privilege.
  • CREATE permission on the dbspaces along with one of:
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the table.
    • You own the table.

Creating a Hash-Range Partition

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • SPACE ADMIN authority, and one of:
    • ALTER permission on the table.
    • You own the table.
SAP Sybase IQ 16.0
Requires one of:
  • ALTER ANY OBJECT system privilege.
  • CREATE permission on the dbspace along with one of:
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the table.
    • You own the table.

Deleting a Partition

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
SAP Sybase IQ 16.0 Table owned by self – None required.
Table owned by other users – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • ALTER permission on the table.

Unpartitioning a Table

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
SAP Sybase IQ 16.0 Table owned by self – None required.
Table owned by other users – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • ALTER permission on the table.

Merging Partitions

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
SAP Sybase IQ 16.0 Table owned by self – None required.
Table owned by other users – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • ALTER permission on the table.

Splitting Partitions

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
  • SELECT permission on the table.
SAP Sybase IQ 16.0 Requires one of:
  • SELECT ANY TABLE system privilege.
  • SELECT permission on table.
Also requires one of:
  • ALTER ANY OBJECT system privilege.
  • CREATE permission on the dbspace along with one of:
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the table.
    • You own the table.

Moving Partitions

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • SPACE ADMIN authority
  • CREATE permission on the dbspace to which the partition is being moved along with one of:
    • ALTER permission on the underlying table.
    • You own the table.
SAP Sybase IQ 16.0
Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • MANAGE ANY DBSPACE system privilege.
  • One of the following:
    • CREATE ANY OBJECT system privilege.
    • CREATE permission on the dbspace to which the partition is being moved.
    • Along with one of:
      • ALTER permission on the underlying table.
      • You own the underlying table.

Managing Column Storage in a Table Partition

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:
  • DBA authority.
  • SPACE ADMIN authority
  • CREATE permission on the dbspace to which the partition is being moved along with one of:
    • ALTER permission on the underlying table.
    • You own the table.
Modify any other table partition property:
  • Table owned by self – None required.
  • Table owned by other users – Requires one of:
    • DBA authority.
    • ALTER permission on the table.
SAP Sybase IQ 16.0 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • MANAGE ANY DBSPACE system privilege.
  • One of the following:
    • CREATE ANY OBJECT system privilege.
    • CREATE permission on the dbspace to which the partition is being moved.
    • Along with one of:
      • ALTER permission on the underlying table.
      • You own the underlying table.

Modify any other table partition property:

  • Table owned by self – None required.
  • Table owned by other users – Requires one of:
    • ALTER ANY TABLE system privilege.
    • ALTER ANY OBJECT system privilege.
    • ALTER permission on the table.

Viewing or Modifying Table Partition Properties

Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:
  • DBA authority.
  • SPACE ADMIN authority
  • CREATE permission on the dbspace to which the partition is being moved along with one of:
    • ALTER permission on the underlying table.
    • You own the table.
Modify any other table partition property:
  • Table owned by self – None required.
  • Table owned by other users – Requires one of:
    • DBA authority.
    • ALTER permission on the table.
SAP Sybase IQ 16.0 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • MANAGE ANY DBSPACE system privilege.
  • One of the following:
    • CREATE ANY OBJECT system privilege.
    • CREATE permission on the dbspace to which the partition is being moved.
    • Along with one of:
      • ALTER permission on the underlying table.
      • You own the underlying table.

Modify any other table partition property:

  • Table owned by self – None required.
  • Table owned by other users – Requires one of:
    • ALTER ANY TABLE system privilege.
    • ALTER ANY OBJECT system privilege.
    • ALTER permission on the table.
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