A list of the system privileges and object permissions required to complete the various table tasks.
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:
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:
|
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:
|
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:
|
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:
|
SAP Sybase IQ 16.0 |
You must have one of the following for the menu option to be enabled:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 |
None |
SAP Sybase IQ 16.0 |
None |
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 |
You must have one of:
|
SAP Sybase IQ 16.0 |
You must have one of:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have the VALIDATE ANY OBJECT system privilege. |
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | To create a new or modify an existing primary key – you must have one of:
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:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported |
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
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:
|
SAP Sybase IQ 16.0 | You must have CREATE permission on the target dbspace. You must also
have one of:
|
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported |
SAP Sybase IQ 16.0 | You must have one of:
|
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:
Modify any property on the General page – you must have one of:
Modify any property on the Miscellaneous page – you must have one of:
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:
Modify the table name on the General page – you must have one of:
Use the Calculate button on the Miscellaneous page – you must have one of:
Modify any other property on the Miscellaneous page for an IQ catalog
(system) store table – you must have one of:
Modify a comment on the General page – you must have one of:
For privileges needed to modify other table properties, see:
|
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:
Modify any property on the General page – you must have one of:
Modify any property on the Miscellaneous page – you must have one of:
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:
Modify the table name on the General page – you must have one of:
Use the Calculate button on the Miscellaneous page – you must have one of:
Modify any other property on the Miscellaneous page for an IQ catalog
(system) store table – Requires one of:
Modify a comment on the General page – you must have one of:
For privileges needed to modify other table properties, see:
|
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:
Modify any property on the General or Miscellaneous page – you must have
one of:
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:
Use the Calculate button on the Miscellaneous page – you must have one of:
Modify a comment on the General page – you must have one of:
For privileges needed to modify other table properties, see:
|