Table Column Privilege Summary

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

Adding a Column

Database Version	Table Column Privileges
SAP Sybase IQ 15.3 and 15.4	Create a column without a primary key or unique constraint – you must have one of: DBA authority Both ALTER permission on the table You own the underlying table Create a column with a primary key or unique constraint – you must have one of: DBA authority Both ALTER and REFERENCE permission on the table You own the underlying table
SAP Sybase IQ 16.0	Create a column without a primary key or unique constraint – you must have one of: ALTER ANY OBJECT system privilege CREATE permission on the dbspace along with one of the following: ALTER ANY TABLE system privilege ALTER permission on the underlying table You own the underlying table Create a column with a primary key or unique constraint – you must have one of: ALTER ANY OBJECT system privilege CREATE permission on the dbspace along with one of the following: ALTER ANY TABLE system privilege Both ALTER and REFERENCE permission on the underlying table You own the underlying table

Database Version

Table Column Privileges

SAP Sybase IQ 15.3 and 15.4

Create a column without a primary key or unique constraint – you must have one of:

Create a column with a primary key or unique constraint – you must have one of:

SAP Sybase IQ 16.0

Create a column without a primary key or unique constraint – you must have one of:

ALTER ANY OBJECT system privilege
CREATE permission on the dbspace along with one of the following:
- ALTER ANY TABLE system privilege
- ALTER permission on the underlying table
- You own the underlying table

Create a column with a primary key or unique constraint – you must have one of:

ALTER ANY OBJECT system privilege
CREATE permission on the dbspace along with one of the following:
- ALTER ANY TABLE system privilege
- Both ALTER and REFERENCE permission on the underlying table
- You own the underlying table

Database Version	Table Column Privileges
SAP Sybase IQ 15.3 and 15.4	Deleting a column without a primary key or unique constraint – you must have one of: DBA authority Both ALTER permission on the table You own the underlying table Deleting a column with a primary key or unique constraint – you must have one of: DBA authority Both ALTER and REFERENCE permission on the table You own the underlying table
SAP Sybase IQ 16.0	Deleting a column without a primary key or unique constraint – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege ALTER permission on the underlying table You own the underlying table Deleting a column with a primary key or unique constraint – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege Both ALTER and REFERENCE permission on the underlying table You own the underlying table

Database Version

Table Column Privileges

SAP Sybase IQ 15.3 and 15.4

Deleting a column without a primary key or unique constraint – you must have one of:

Deleting a column with a primary key or unique constraint – you must have one of:

SAP Sybase IQ 16.0

Deleting a column without a primary key or unique constraint – you must have one of:

Deleting a column with a primary key or unique constraint – you must have one of:

Database Version	Table Column Privileges
SAP Sybase IQ 15.3 and 15.4	View any table column property page – – none. Modify the Primary key property on the General page – you must have one of: DBA authority Both ALTER and REFERENCE permission on the table You own the table Modify any other table column property – you must have one of: DBA authority ALTER permission on the table You own the table
SAP Sybase IQ 16.0	View any table column property page – – none. Modify the Primary key property on the General page – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege Both ALTER and REFERENCE permission on the table You own the table Modify a table column comment – 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 any other table column property – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege ALTER permission on the table You own the table

Database Version

Table Column Privileges

SAP Sybase IQ 15.3 and 15.4

View any table column property page – – none.

Modify the Primary key property on the General page – you must have one of:

Modify any other table column property – you must have one of:

SAP Sybase IQ 16.0

View any table column property page – – none.

Modify the Primary key property on the General page – you must have one of:

Modify a table column comment – you must have one of:

Modify any other table column property – you must have one of: