Authority-Based User Privilege Summary

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 –
  • Requires DBA authority.
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.
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