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 You must have 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 You must have 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 You must have 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 You must have 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.
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.
Modify a password – you must have one of:
  • DBA authority
  • USER ADMIN authority
  • PERMS ADMIN authority
Modify a login policy – you must have one of:
  • DBA authority
  • USER ADMIN authority

Modify any other user property except those relating to permissions – you must have 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 You must have 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 You must have 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 You must have 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 You must have 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 You must have one of:
  • DBA authority
  • PERMS ADMIN authority
SAP Sybase IQ 16.0 Not supported.
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