A list of the system privileges and object permissions
required to complete the various
role-based user, user-extended role, or standalone role tasks relating to database
objects.
Grant or Revoke Permissions on a Table or Column
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| 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
|
Modify Administrative Permissions on a Table or Column
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| 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
|
Grant or Revoke Permissions on a View or Materialized View
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| 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
|
Modify Administrative Permissions on a View or Materialized View
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| 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
|
Grant or Revoke Permissions on a Function or Procedure
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
You must have
one of:- MANAGE ANY OBJECT PRIVILEGE system
privilege
- You own the database object
|
Grant or Revoke Permissions on a Sequence Generator
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
You must
have one of:- MANAGE ANY OBJECT PRIVILEGE system
privilege
- You own the sequence generator
|
Grant or Revoke Permissions on a Dbspace
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
You
must have the MANAGE ANY DBSPACE system privilege. |