Table Constraints Privilege Summary

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

Creating a Column Check Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • ALTER permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • You have ALTER permission on the underlying table.
  • You own the underlying table.

Creating a Foreign Key Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • Requires one of:
    • ALTER permission on the derived table
    • You own the derived table.
    • Also requires one of:
      • REFERENCE permission on the base table.
      • You own the base table.
    • Also requires one of:
      • REFERENCE permission on the derived table (to index it)
      • You own the derived table.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY OBJECT system privilege.
  • CREATE permission on the dbspace the table is defined on, along with one of:
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the derived table.
    • You own the derived table.
Also requires one of:
  • CREATE ANY INDEX system privilege.
  • CREATE ANY OBJECT system privilege.
  • REFERENCE permission on the base table.

Creating a Table Check Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • ALTER permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • You have ALTER permission on the underlying table.
  • You own the underlying table.

Creating a Unique Constraint

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

Deleting a Table or Column Check Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • ALTER permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0
Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • ALTER permission on the underlying table.
  • You own the underlying table.

Deleting a Unique, Primary or Foreign Key Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • ALTER and REFERENCE permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0
Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • ALTER and REFERENCE permission on the underlying table.
  • You own the underlying table.

Rebuilding a Unique, Primary or Foreign Key Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • REFERENCE permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY INDEX system privilege.
  • REFERENCE permission on the underlying table.
  • You own the underlying table.

Validating a Constraint

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • VALIDATE authority.
SAP Sybase IQ 16.0 Requires VALIDATE ANY OBJECT system privilege.

Generating Constraint DDL Commands

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4

None required.
SAP Sybase IQ 16.0

None required.

Viewing or Modifying Constraint Properties

Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4

View table constraint properties – None required.

Modify comment on foreign key or unique constraint – Requires one of:
  • DBA authority.
  • ALTER permission on the underlying table.
  • You own the underlying table.
SAP Sybase IQ 16.0

View any table constraint property page – None required.

Modify the comment on a foreign or primary key constraint – Requires one of:
  • CREATE ANY TABLE system privilege.
  • ALTER ANY TABLE system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
  • COMMENT ANY OBJECT system privilege.
  • You own the table.
Modify the comment on a unique key constraint – Requires one of:
  • CREATE ANY INDEX system privilege.
  • ALTER ANY INDEX system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
  • COMMENT ANY OBJECT system privilege.
  • You own the table.
Modify the definition of a table or column check constraint – Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • ALTER permission on the table.
  • You own the table.
Modify any foreign key constraint property on the Action page – Requires one of:
  • CREATE ANY OBJECT system privilege.
  • CREATE ANY INDEX system privilege.
  • Also requires one of:
    • ALTER ANY OBJECT system privilege.
    • ALTER ANY TABLE system privilege.
    • ALTER permission on the underlying table.
    • You own the table.
Modify any other property of a primary, foreign or unique key, table check or column check constraint – Requires one of:
  • ALTER ANY OBJECT system privilege.
  • ALTER ANY TABLE system privilege.
  • ALTER permission on the underlying table.
  • You own the underlying table.
Parent topic: Table Constraints
Related tasks
Creating a Column Check Constraint
Creating a Foreign Key Constraint
Creating a Table Check Constraint
Creating a Unique Constraint
Deleting a Table or Column Check Constraint
Deleting a Primary, Foreign, or Unique Key Constraint
Rebuilding a Unique, Primary or Foreign Key Constraint
Validating a Unique, Primary or Foreign Key Constraint
Generating Constraint DDL Commands
Viewing or Modifying Constraint Properties