Viewing and Modifying Proxy Table Properties

Display the properties of the selected proxy table. Only the Comment property is editable.

Prerequisites

Note: The system privileges and permissions required vary by task. Unless otherwise indicated, the following system privileges and permissions apply.

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:

The SAP Sybase IQ resource is authenticated and running.
(Modifying properties only) In a multiplex configuration, the coordinator node is running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Proxy Tables.
In the right pane, select a table, click the drop-down arrow that appears next to the table name and select Properties.

View or modify table properties.

When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Area	Description
General	Name – (Read-only) Table identifier. Owner – (Read-only) Database user who owns the table. Remote location – Read-only) Shows the location of the remote table that the proxy table is based on. Comment – Text description of the table. For example, describe the table's purpose in the system.
Columns	See Table Columns.
Triggers	See Table Triggers.
Data (Read-only)	Requires SELECT permission on the base table on the remote server. Note: For 15.3 and 15.4, requires SELECT permission on the table to view data. For 16.0, requires the SELECT ANY TABLE ROLE system privilege to view data. Displays the first 500 rows of data.
Miscellaneous Read-only)	Number of rows – Approximate number of rows in the table. To update this value, click Calculate. Calculate – Calculates the number of rows in the table. Number of Columns – Number of columns in the table. Time Created – Date and time the table was created. Time Updated – Date and time the table was last updated.

Click OK.