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: Authority-Based Users
Related tasks
Creating an Authority-Based User
Deleting an Authority-Based User
Converting an Authority-Based User to a Group
Viewing or Modifying Authority-Based User Options
Generating Authority-Based User DDL Commands
Viewing or Modifying Authority-Based User Properties
Changing an Authority-Based User Password
Forcing an Authority-Based User to Change their Password
Unlocking an Authority-Based User Account
Changing an Authority-Based User Login Policy
Adding an Authority to an Authority-Based User
Removing an Authority from an Authority-Based User