Table Constraints Privilege Summary

Creating a Column Check Constraint

Database Version	Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority ALTER permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have DBA authority or have one of: ALTER permission on the derived table You own the derived table In addition, if you do not have DBA authority, you must also have one of: REFERENCE permission on the base table You own the base table Finally, if you do not have DBA authority, you must also have one of: REFERENCE permission on the derived table (to index it) You own the derived table
SAP Sybase IQ 16.0	You must have 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 You must also have one of: CREATE ANY INDEX system privilege CREATE ANY OBJECT system privilege REFERENCE permission on the base table

Database Version

Table Constraint Privileges

SAP Sybase IQ 15.3 and 15.4

You must have DBA authority or have one of:

ALTER permission on the derived table
You own the derived table

In addition, if you do not have DBA authority, you must also have one of:

REFERENCE permission on the base table
You own the base table

Finally, if you do not have DBA authority, you must also have one of:

REFERENCE permission on the derived table (to index it)
You own the derived table

SAP Sybase IQ 16.0

You must have 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

You must also have 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	You must have one of: DBA authority ALTER permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority ALTER and REFERENCE permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority ALTER permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority ALTER and REFERENCE permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority REFERENCE permission on the underlying table You own the underlying table
SAP Sybase IQ 16.0	You must have 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	You must have one of: DBA authority VALIDATE authority
SAP Sybase IQ 16.0	You must have the VALIDATE ANY OBJECT system privilege

Generating Constraint DDL Commands

Database Version	Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4	None
SAP Sybase IQ 16.0	None

Viewing or Modifying Constraint Properties

Database Version	Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4	View table constraint properties – none Modify comment on foreign key or unique constraint – you must have 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 Modify the comment on a foreign or primary key constraint – you must have 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 – you must have 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 – you must have 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 – you must have one of: CREATE ANY OBJECT system privilege CREATE ANY INDEX system privilege You must also have 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 – you must have one of: ALTER ANY OBJECT system privilege ALTER ANY TABLE system privilege ALTER permission on the underlying table You own the underlying table

Database Version

Table Constraint Privileges

SAP Sybase IQ 15.3 and 15.4

View table constraint properties – none

Modify comment on foreign key or unique constraint – you must have 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

Modify the comment on a foreign or primary key constraint – you must have 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 – you must have 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 – you must have 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 – you must have one of:

CREATE ANY OBJECT system privilege
CREATE ANY INDEX system privilege

You must also have 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 – you must have one of:

ALTER ANY OBJECT system privilege
ALTER ANY TABLE system privilege
ALTER permission on the underlying table
You own the underlying table