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 – Requires 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 – Requires 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 – Requires 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 – Requires 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 – Requires one of:

Create a column with a primary key or unique constraint – Requires one of:

SAP Sybase IQ 16.0

Create a column without a primary key or unique constraint – Requires 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 – Requires 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 – Requires 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 – Requires 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 – Requires 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 – Requires 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 – Requires one of:

Deleting a column with a primary key or unique constraint – Requires one of:

SAP Sybase IQ 16.0

Deleting a column without a primary key or unique constraint – Requires one of:

Deleting a column with a primary key or unique constraint – Requires one of:

Database Version	Table Column Privileges
SAP Sybase IQ 15.3 and 15.4	View any table column property page – None required. Modify the Primary key property on the General page – Requires one of: DBA authority. Both ALTER and REFERENCE permission on the table. You own the table. Modify any other table column property – Requires 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 required. Modify the Primary key property on the General page – Requires 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 – 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 any other table column property – Requires 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 required.

Modify the Primary key property on the General page – Requires one of:

Modify any other table column property – Requires one of:

SAP Sybase IQ 16.0

View any table column property page – None required.

Modify the Primary key property on the General page – Requires one of:

Modify a table column comment – Requires one of:

Modify any other table column property – Requires one of: