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 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:

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 left pane, expand IQ Servers > Schema Objects > Tables, and then select Proxy Tables.
Select a table from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Proxy Table Properties view appears.

View or modify table properties.

When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
If you do not have privileges to modify properties, SAP 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.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.