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 Creating a user requires MANAGE ANY USER system privilege.
Granting a role during the user creation process requires 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.

Granting a system privilege during user creation requires 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 Requires 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 Requires 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 Requires 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 Requires 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 required.
Modify any option – Depending on the option being modified, requires one of these:
  • 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 required.

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 required.

Modify a password – Requires CHANGE PASSWORD system privilege.

Modify a login policy, comment, or refresh DN – Requires MANAGE ANY USER system privilege.

Refresh LDAP DN - Requires 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 Requires 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 Requires 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 Requires 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 Requires MANAGE ANY USER system privilege.
Parent topic: Configuring SAP Sybase IQ for Administration
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