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.
Table owned by other users – you must have one of:
  • DBA authority
  • ALTER permission on the table
SAP Sybase IQ 16.0 You must have 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

Creating a Range Partition

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

You must also have one of:

  • ALTER permission on the table
  • You own the table
SAP Sybase IQ 16.0 You must have one of:
  • 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 You must have one of:
  • DBA authority
  • SPACE ADMIN authority, along with one of:
    • ALTER permission on the table
    • You own the table
SAP Sybase IQ 16.0
You must have 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.
Table owned by other users – you must have one of:
  • DBA authority
  • ALTER permission on the table
SAP Sybase IQ 16.0 Table owned by self – none.
Table owned by other users – you must have 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.
Table owned by other users – you must have one of:
  • DBA authority
  • ALTER permission on the table
SAP Sybase IQ 16.0 Table owned by self – none.
Table owned by other users – you must have 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.
Table owned by other users – you must have one of:
  • DBA authority
  • ALTER permission on the table
SAP Sybase IQ 16.0 Table owned by self – none.
Table owned by other users – you must have 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.
Table owned by other users – you must have one of:
  • DBA authority
  • ALTER permission on the table
  • SELECT permission on the table
SAP Sybase IQ 16.0 You must have one of:
  • SELECT ANY TABLE system privilege
  • SELECT permission on table
You must also have 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 You must have 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
You must have 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.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have 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.
  • Table owned by other users – you must have one of:
    • DBA authority
    • ALTER permission on the table
SAP Sybase IQ 16.0 View any table partition property page – none.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have 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.
  • Table owned by other users – you must have 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.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have 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.
  • Table owned by other users – you must have one of:
    • DBA authority
    • ALTER permission on the table
SAP Sybase IQ 16.0 View any table partition property page – none.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have 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.
  • Table owned by other users – you must have one of:
    • ALTER ANY TABLE system privilege
    • ALTER ANY OBJECT system privilege
    • ALTER permission on the table
Parent topic: Table Partitions
Related tasks
Creating a Range Partition on an Existing Table
Creating a Range Subpartition to an Existing Hash-Range Partitioned Table
Deleting a Range Partition or Subpartition
Unpartitioning a Table
Rebuilding a Hash or Hash-Range Partitioned Table
Merging Partitions
Splitting a Partition
Moving a Partition
Managing Column Storage in a Table Partition
Viewing or Modifying Table Partition Properties