Table Privilege Summary

Creating a Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Base table to be owned by self – you must have RESOURCE authority with CREATE permission on the main store dbspace in which the table is created. Base table to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Base table to be owned by self – you must have CREATE permission on the dbspace where the table is created. You must also have one of: CREATE TABLE system privilege CREATE ANY OBJECT system privilege Base table to be owned by any user – you must have CREATE permission on the dbspace where the table is created. You must also have one of: CREATE ANY TABLE system privilege CREATE ANY OBJECT system privilege

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

Base table to be owned by self – you must have RESOURCE authority with CREATE permission on the main store dbspace in which the table is created.

Base table to be owned by any user – you must have DBA authority.

SAP Sybase IQ 16.0

Base table to be owned by self – you must have CREATE permission on the dbspace where the table is created. You must also have one of:

CREATE TABLE system privilege
CREATE ANY OBJECT system privilege

Base table to be owned by any user – you must have CREATE permission on the dbspace where the table is created. You must also have one of:

CREATE ANY TABLE system privilege
CREATE ANY OBJECT system privilege

Creating a Global Temporary Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Global temporary table to be owned by self – you must have RESOURCE authority with CREATE permission on the main store dbspace in which the table is created. Global temporary table to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Global temporary table to be owned by self – you must have the CREATE TABLE system privilege. Global temporary table to be owned by any user – you must have one of: CREATE ANY TABLE system privilege CREATE ANY OBJECT system privilege

Creating a Proxy Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Proxy table to be owned by self – you must have RESOURCE authority with CREATE permission on the main store dbspace in which the table is created. Proxy table to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Proxy table to be owned by self – you must have CREATE PROXY TABLE system privilege. Proxy table to be owned by any user – you must have one of: CREATE ANY TABLE system privilege CREATE ANY OBJECT system privilege

Viewing Table Data in the Execute SQL Windows

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of the following for the menu option to be enabled: DBA authority SELECT permission on the table You own the table Queries execute with the user's current permissions.
SAP Sybase IQ 16.0	You must have one of the following for the menu option to be enabled: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Queries execute with the user's current privileges.

Deleting a Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the table
SAP Sybase IQ 16.0	You must have one of: DROP ANY TABLE system privilege DROP ANY OBJECT system privilege You own the table

Generating Table DDL Commands

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

Moving a Table to Another Dbspace

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority You own the table and have CREATE permission on the target dbspace
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 ALTER permission on the table and CREATE permission on the target dbspace You own the table and have CREATE permission on the target dbspace

Validating a System Store Table

Database Version	Table 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.

Setting the Primary Key

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority ALTER and REFERENCE permission on the table You own the table
SAP Sybase IQ 16.0	To create a new or modify an existing primary key – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege CREATE permission on the dbspace where the table resides ALTER and REFERENCE permission on the table You own the table To modify the name only of an existing primary key, you must have the ALTER ANY INDEX system privilege.

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
ALTER and REFERENCE permission on the table
You own the table

SAP Sybase IQ 16.0

To create a new or modify an existing primary key – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
CREATE permission on the dbspace where the table resides
ALTER and REFERENCE permission on the table
You own the table

To modify the name only of an existing primary key, you must have the ALTER ANY INDEX system privilege.

Setting a Clustered Index

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

Moving Table Data from RLV Store to IQ Main Store

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported
SAP Sybase IQ 16.0	You must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege

Calculating the Number of Rows in a Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SELECT permission on the table You own the table
SAP Sybase IQ 16.0	You must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table

Moving Table Objects to Another Dbspace

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	You must have CREATE permission on the target dbspace. You must also have one of: DBA authority RESOURCE authority with ALTER permission on the table You own the table
SAP Sybase IQ 16.0	You must have CREATE permission on the target dbspace. You must also have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege MANAGE ANY DBSPACE system privilege You own the table

Enabling Row-Level Versioning in a Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported
SAP Sybase IQ 16.0	You must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege

Viewing or Modifying Base Table Properties

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	View any property page of a base table owned by self – none. View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of: DBA authority SELECT permission on the table You own the table Modify any property on the General page – you must have one of: DBA authority ALTER permission on the table You own the table Modify any property on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary Table Partition Privilege Summary
SAP Sybase IQ 16.0	View any property page of a base table owned by self – none. View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify the table name on the General page – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege You own the table Use the Calculate button on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege ALTER permission on the table You own the table Modify a comment on the General page – 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 For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary Table Partition Privilege Summary

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

View any property page of a base table owned by self – none.

View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of:

DBA authority
SELECT permission on the table
You own the table

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

DBA authority
ALTER permission on the table
You own the table

Modify any property on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

For privileges needed to modify other table properties, see:

SAP Sybase IQ 16.0

View any property page of a base table owned by self – none.

View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify the table name on the General page – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
You own the table

Use the Calculate button on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – you must have one of:

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

Modify a comment on the General page – 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

For privileges needed to modify other table properties, see:

Viewing or Modifying Global Temporary Table Properties

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	View any property page of a global temporary table owned by self – none. View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you need one of: DBA authority SELECT permission on the table You own the table Modify any property on the General page – you must have one of: DBA authority ALTER permission on the table You own the table Modify any property on the Miscellaneous page – you must have one of: SELECT permission on the table You own the table For permissions needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary
SAP Sybase IQ 16.0	View any property page of a global temporary table owned by self – none. View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify the table name on the General page – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege You own the table Use the Calculate button on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – Requires one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege ALTER permission on the table You own the table Modify a comment on the General page – 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 For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

View any property page of a global temporary table owned by self – none.

View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you need one of:

DBA authority
SELECT permission on the table
You own the table

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

DBA authority
ALTER permission on the table
You own the table

Modify any property on the Miscellaneous page – you must have one of:

SELECT permission on the table
You own the table

For permissions needed to modify other table properties, see:

SAP Sybase IQ 16.0

View any property page of a global temporary table owned by self – none.

View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify the table name on the General page – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
You own the table

Use the Calculate button on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – Requires one of:

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

Modify a comment on the General page – 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

For privileges needed to modify other table properties, see:

Viewing or Modifying Proxy Table Properties

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	View any property page of a proxy table owned by self – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server. View any properties of a proxy table owned by any user – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server along with one of: DBA authority SELECT permission on the table Modify any property on the General or Miscellaneous page – you must have one of: DBA authority You own the table For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Trigger Privilege Summary
SAP Sybase IQ 16.0	View any property page of a proxy table owned by self – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server. View any property page of a proxy table owned by any user – none needed except for the Data page, for which you must have one of: SELECT ANY TABLE system privilege SELECT permission on the proxy table SELECT permission on the base table You own the table Use the Calculate button on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the proxy table You own the table Modify a comment on the General page – 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 For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Trigger Privilege Summary

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

View any property page of a proxy table owned by self – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server.

View any properties of a proxy table owned by any user – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server along with one of:

DBA authority
SELECT permission on the table

Modify any property on the General or Miscellaneous page – you must have one of:

DBA authority
You own the table

For privileges needed to modify other table properties, see:

SAP Sybase IQ 16.0

View any property page of a proxy table owned by self – none needed except for the Data page, for which you must have SELECT permission on the base table on the remote server.

View any property page of a proxy table owned by any user – none needed except for the Data page, for which you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the proxy table
SELECT permission on the base table
You own the table

Use the Calculate button on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the proxy table
You own the table

Modify a comment on the General page – 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

For privileges needed to modify other table properties, see: