A list of the system privileges and object permissions required to complete the various role-based user tasks.
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | Create a user – you must have the MANAGE ANY USER system privilege. Grant a role during the user creation process – you
must have one of:
Grant a system privilege during user creation – you must have administrative rights over the system privilege being granted. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | You must have the MANAGE ANY USER system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | You must have the MANAGE ROLES system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | You must have administrative rights over the system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 | View the list of options – none. Modify any option –
Depending on the option being modified, you must have one of:
|
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not supported. |
SAP Sybase IQ 16.0 | None. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 |
View any user property page – none. Modify a password – you must have the CHANGE PASSWORD system privilege. Modify a login policy, comment, or refresh DN – you must have the MANAGE ANY USER system privilege. Refresh LDAP DN - You must have the MANAGE ANY USER system privilege. For privileges relating to user permissions, see:
|
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 | You must have the MANAGE ANY USER system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 | You must have the CHANGE PASSWORD system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 | You must have the MANAGE ANY USER system privilege. |
Database Version | Role-Based User Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Not Supported. |
SAP Sybase IQ 16.0 | You must have the MANAGE ANY USER system privilege. |