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: Role-Based Users
Related tasks
Creating a Role-Based User
Deleting a Role-Based User
Converting a Role-Based User to a User-Extended Role
Adding a Role to a Role-Based User
Changing a Role-Based User's Administrative Rights on a Role
Removing a Role from a Role-Based User
Adding a System Privilege to a Role-Based User
Changing a User's Administrative Rights on a System Privilege
Removing a System Privilege from a Role-Based User
Viewing or Modifying Role-Based User Options
Generating Role-Based User DDL Commands
Viewing or Modifying Role-Based User Properties
Changing a Role-Based User Password
Forcing a Role-Based User to Change their Password
Unlocking a Role-Based User Account
Changing a Role-Based User Login Policy