A list of the system privileges and object permissions
required to complete the various
table permission tasks.
Grant and Revoke Permissions on a Table
| Database Version |
Database Object Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
You must have one
of:- DBA authority
- PERMS ADMIN authority
- You have administrative rights (with grant
option) to the permission
- You own the database object
|
| SAP Sybase IQ
16.0 |
You must have
one of:- MANAGE ANY OBJECT PRIVILEGE system
privilege
- You have administrative rights (with grant
option) to the permission
- You own the database object
|
Adjust Administration Permissions on a Table
| Database Version |
Database Object Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
You must
have one of:- DBA authority
- PERMS ADMIN authority
- You own the database object
|
| SAP Sybase IQ
16.0 |
You must
have one of:- MANAGE ANY OBJECT PRIVILEGE system
privilege
- You have administrative rights to the
permission being modified
- You own the database object
|