To complete operations on tables that are hosted by Sybase
ASE and Sybase IQ databases, you require specific privileges on the
table.
Table 1. Permissions required to access Sybase databases. You require write, read, upsert and lookup privileges on
the table to complete operations on tables that are hosted by Sybase
ASE and Sybase IQ databases.
| Operation |
Options |
Syspartition (only for
Sybase ASE) |
sysobjects |
SELECT privilege on table |
INSERT privilege on table |
Delete table |
Create table |
| Write |
Create/Replace |
Yes |
Yes |
No |
No |
No |
Yes |
| Write |
Append |
Yes |
Yes |
Yes |
Yes |
No |
No |
| Write |
Truncate |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
| Read |
All |
No |
Yes |
Yes |
No |
No |
No |
| Upsert |
Update/Insert |
- UPDATE privilege on the table that you want to
update.
- INSERT privilege on the table into which you
want to insert records.
|
- UPDATE privilege on the table that you want to
update.
- INSERT privilege on the table into which you
want to insert records.
|
- UPDATE privilege on the table that you want to
update.
- INSERT privilege on the table into which you
want to insert records.
|
- UPDATE privilege on the table that you want to
update.
- INSERT privilege on the table into which you
want to insert records.
|
- UPDATE privilege on the table that you want to update.
- INSERT privilege on the table into which you
want to insert records.
|
- UPDATE privilege on the table that you want to
update.
- INSERT privilege on the table into which you
want to insert records.
|
| Lookup |
All |
No |
Yes |
Yes |
No |
No |
No |