A list of the system privileges and object permissions
required to complete the various
authority-based user tasks.
Creating an Authority-Based User
| Database Version |
Authority-Based User 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 User
| Database Version |
Authority-Based User 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 User to a Group
| Database Version |
Authority-Based User 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 User Options
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires DBA authority. |
| SAP Sybase IQ
16.0 |
Not supported. |
Generating Authority-Based User DDL Commands
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
None required. |
| SAP Sybase IQ
16.0 |
Not supported. |
Viewing or Modifying Authority-Based User Properties
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
View any user 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 user property except those relating to
permissions –
For privileges relating to user permissions, see:
|
| SAP Sybase IQ
16.0 |
Not Supported. |
Changing an Authority-Based User Password
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not Supported. |
Forcing an Authority-Based User Password Change
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not Supported. |
Unlocking an Locked Authority-Based User Account
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not Supported. |
Changing an Authority-Based User Login Policy
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not Supported. |
Granting or Revoking an Authority from a User
| Database Version |
Authority-Based User Permissions |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Not supported. |