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: Requires RESOURCE authority with CREATE permission on the main store dbspace in which the table is created. Base table to be owned by any user – Requires DBA authority.
SAP Sybase IQ 16.0	Base table to be owned by self – Requires CREATE permission on the dbspace where the table is created. Also requires one of: CREATE TABLE system privilege. CREATE ANY OBJECT system privilege Base table to be owned by any user – Requires CREATE permission on the dbspace where the table is created. Also requires 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:

Requires RESOURCE authority with CREATE permission on the main store dbspace in which the table is created.

Base table to be owned by any user – Requires DBA authority.

SAP Sybase IQ 16.0

Base table to be owned by self –

Requires CREATE permission on the dbspace where the table is created.
Also requires one of:
- CREATE TABLE system privilege.
- CREATE ANY OBJECT system privilege

Base table to be owned by any user –

Requires CREATE permission on the dbspace where the table is created.
Also requires 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: Requires 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 – Requires DBA authority.
SAP Sybase IQ 16.0	Global temporary table to be owned by self: Requires CREATE TABLE system privilege. Global temporary table to be owned by any user – Requires one of: CREATE ANY TABLE system privilege. CREATE ANY OBJECT system privilege.

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

Global temporary table to be owned by self:

Requires 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 – Requires DBA authority.

SAP Sybase IQ 16.0

Global temporary table to be owned by self:

Requires CREATE TABLE system privilege.

Global temporary table to be owned by any user – Requires 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: Requires RESOURCE authority with CREATE permission on the main store dbspace in which the table is created. Proxy table to be owned by any user – Requires DBA authority.
SAP Sybase IQ 16.0	Proxy table to be owned by self – Requires CREATE PROXY TABLE system privilege. Proxy table to be owned by any user – Requires one of: CREATE ANY TABLE system privilege CREATE ANY OBJECT system privilege.

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

Proxy table to be owned by self:

Requires RESOURCE authority with CREATE permission on the main store dbspace in which the table is created.

Proxy table to be owned by any user – Requires DBA authority.

SAP Sybase IQ 16.0

Proxy table to be owned by self – Requires CREATE PROXY TABLE system privilege.

Proxy table to be owned by any user – Requires 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	Requires one of the following to enable menu option: DBA authority. SELECT permission on the table. You own the table. Queries execute with user's current permissions.
SAP Sybase IQ 16.0	Requires one of the following to enable menu option: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. Queries execute with user's current privileges.

Deleting a Table

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You own the table.
SAP Sybase IQ 16.0	Requires 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 required.
SAP Sybase IQ 16.0	None required.

Moving a Table to Another Dbspace

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. SPACE ADMIN authority. You own the table and have CREATE permission on the target dbspace.
SAP Sybase IQ 16.0	Requires 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	Requires one of: DBA authority. VALIDATE authority.
SAP Sybase IQ 16.0	Requires VALIDATE ANY OBJECT system privilege.

Setting the Primary Key

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Requires 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 - Requires 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, requires ALTER ANY INDEX system privilege.

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

Requires 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 - Requires 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, requires ALTER ANY INDEX system privilege.

Setting a Clustered Index

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. ALTER permission on the table. You own the table.
SAP Sybase IQ 16.0	Requires 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	Requires 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	Requires one of: DBA authority. SELECT permission on the table. You own the table.
SAP Sybase IQ 16.0	Requires 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	Requires CREATE permission on the target dbspace. Also requires one of: DBA authority. RESOURCE authority with ALTER permission on the table. You own the table.
SAP Sybase IQ 16.0	Requires CREATE permission on the target dbspace. Also requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. Requires 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	Requires 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 required. View any property page of a base table owned by any user – None required except Data page, which requires one of: DBA authority. SELECT permission on the table. You own the table. Modify any property on the General page requires one of: DBA authority. ALTER permission on the table. You own the table. Modify any property on the Miscellaneous page requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. For privileges required 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 required. View any property page of a base table owned by any user – None required except Data page, which requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. Modify the table name on the General page – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. You own the table. Use the Calculate button on the Miscellaneous page – Requires 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 – 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. For privileges required 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 required.

View any property page of a base table owned by any user – None required except Data page, which requires one of:

DBA authority.
SELECT permission on the table.
You own the table.

Modify any property on the General page requires one of:

DBA authority.
ALTER permission on the table.
You own the table.

Modify any property on the Miscellaneous page requires one of:

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

For privileges required to modify other table properties, see:

SAP Sybase IQ 16.0

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

View any property page of a base table owned by any user – None required except Data page, which requires one of:

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

Modify the table name on the General page – Requires one of:

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

Use the Calculate button on the Miscellaneous page – Requires 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 – 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.

For privileges required 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 required. View any property page of a global temporary table owned by any user – None required except Data page, which requires one of: DBA authority. SELECT permission on the table. You own the table. Modify any property on the General page requires one of: DBA authority. ALTER permission on the table. You own the table. Modify any property on the Miscellaneous page requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. For privileges required 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 required. View any property page of a global temporary table owned by any user – None required except Data page, which requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. Modify the table name on the General page – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. You own the table. Use the Calculate button on the Miscellaneous page – Requires 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 – 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. For privileges required 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 required.

View any property page of a global temporary table owned by any user – None required except Data page, which requires one of:

DBA authority.
SELECT permission on the table.
You own the table.

Modify any property on the General page requires one of:

DBA authority.
ALTER permission on the table.
You own the table.

Modify any property on the Miscellaneous page requires one of:

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

For privileges required to modify other table properties, see:

SAP Sybase IQ 16.0

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

View any property page of a global temporary table owned by any user – None required except Data page, which requires one of:

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

Modify the table name on the General page – Requires one of:

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

Use the Calculate button on the Miscellaneous page – Requires 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 – 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.

For privileges required 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 required except for Data page, which requires SELECT permission on the base table on the remote server. View any properties of a proxy table owned by any user – None required except for Data page, which requires: SELECT permission on the base table on the remote server. Also requires one of: DBA authority. SELECT permission on the table. Modify any property on the General or Miscellaneous page requires one of: DBA authority. You own the table. For privileges required 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 required except for Data page, which requires SELECT permission on the base table on the remote server. View any property page of a proxy table owned by any user – None required except Data page, which requires 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 – Requires one of: SELECT ANY TABLE system privilege. SELECT permission on the proxy table. You own the table. Modify a comment on the General page 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. For privileges required 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 required except for Data page, which requires SELECT permission on the base table on the remote server.

View any properties of a proxy table owned by any user – None required except for Data page, which requires:

SELECT permission on the base table on the remote server.
Also requires one of:
- DBA authority.
- SELECT permission on the table.

Modify any property on the General or Miscellaneous page requires one of:

DBA authority.
You own the table.

For privileges required to modify other table properties, see:

SAP Sybase IQ 16.0

View any property page of a proxy table owned by self – None required except for Data page, which requires SELECT permission on the base table on the remote server.

View any property page of a proxy table owned by any user – None required except Data page, which requires 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 – Requires one of:

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

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

For privileges required to modify other table properties, see: