Authority-Based Group Privilege Summary

A list of the system privileges and object permissions required to complete the various authority-based group tasks.

Creating an Authority-Based Group

Database Version Authority-Based Group 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 Group

Database Version Authority-Based Group 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 Group to a User

Database Version Authority-Based Group 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.

Adding Authority-Based Users and Groups to Groups

Database Version Authority-Based Group 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.

Removing Authority-Based Users and Groups from a Group

Database Version Authority-Based Group 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 Group Options

Database Version Authority-Based Group 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.

Generating Authority-Based Group DDL Commands

Database Version Authority-Based Group Permissions
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 Not supported.

Viewing or Modifying Authority-Based Group Properties

Database Version Authority-Based Group Permissions
SAP Sybase IQ 15.3 and 15.4 View any 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 group property except those relating to permissions – you must have DBA authority.

For privileges relating to group permissions, see:
SAP Sybase IQ 16.0 Not supported.

Granting or Revoking an Authority to a Group

Database Version Authority-Based Group 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