A list of the system privileges and object permissions
required to complete the various
authority-based user and group tasks pertaining to database objects.
Grant or Revoke Permissions on a Table or Column
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires 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 |
Not supported. |
Modify Administrative Permissions on a Table or Column
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- You own the database object.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Grant or Revoke Permissions on a View or Materialized View
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- Administrative rights over the permission.
- You own the database object.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Modify Administrative Permissions on a View or Materialized View
| Database Version |
Database Object Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- You own the database object.
|
| SAP Sybase IQ
16.0 |
Requires one of:- MANAGE ANY OBJECT PRIVILEGE system privilege.
- You have administrative rights to the permission being
modified.
- You own the database object.
|
Grant or Revoke Permissions on a Sequence Generator
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- You own the sequence generator.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Grant or Revoke Permissions on a Function or Procedure
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- You own the database object.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Grant or Revoke Permissions on a Dbspace
| Database Version |
Authority-Based Database Object
Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |