Role-Based User Privilege Summary

A list of the system privileges and object permissions required to complete the various role-based user tasks.

Creating a Role-Based User

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:
  • Administrative rights over the role being granted (role administrator)
  • MANAGE ROLES system privilege if the role being granted has a global role administrator

Grant a system privilege during user creation – you must have administrative rights over the system privilege being granted.

Deleting a Role-Based User

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.

Converting a Role-Based User to a User Extended Role

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.

Adding and Removing a User from a Role

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:
  • Administrative rights over the role (role administrator)
  • MANAGE ROLES system privilege if the role has a global role administrator

Adding and Removing System Privileges from a User

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.

Viewing or Modifying Role-Based User Options

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:
  • SET ANY PUBLIC OPTION system privilege
  • SET ANY SECURITY OPTION system privilege
  • SET ANY SYSTEM OPTION system privilege

Generating Role-Based User DDL Commands

Database Version Role-Based User Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 None.

Viewing or Modifying Role-Based User Properties

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:

Changing a Role-Based User Password

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.

Forcing a Role-Based User Password Change

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.

Unlocking a Role-Based User Account

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.

Changing a Role-Based User Login Policy

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.
Parent topic: SAP Sybase IQ Authority and Privilege Reference
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group