A list of the system privileges and object permissions
required to complete the various
authority-based group tasks.
Creating an Authority-Based Group
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- Both USER ADMIN and PERMS ADMIN authorities
|
| SAP Sybase IQ
16.0 |
Not supported. |
Deleting an Authority-Based Group
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Converting an Authority-Based Group to a User
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Adding Authority-Based Users and Groups to Groups
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Removing Authority-Based Users and Groups from a Group
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Viewing or Modifying Authority-Based Group Options
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |
Generating Authority-Based Group DDL Commands
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
None required. |
| SAP Sybase IQ
16.0 |
Not supported. |
Viewing or Modifying Authority-Based Group Properties
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
View any property page – None required.Modify a password –
Requires one of: - DBA authority.
- USER ADMIN authority.
- PERMS ADMIN authority.
Modify a login policy – Requires one of: - DBA authority.
- USER ADMIN authority.
Modify any other group property except those relating to
permissions –
For privileges relating to group permissions, see:
|
| SAP Sybase IQ
16.0 |
Not supported |
Granting or Revoking an Authority to a Group
| Database Version |
Authority-Based Group Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |