Domain Privilege Summary

A list of the system privileges and object permissions required to complete the various domain tasks.

Creating a Domain

Database Version Domain Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • RESOURCE authority.
SAP Sybase IQ 16.0 Requires one of:
  • CREATE DATATYPE system privilege.
  • CREATE ANY OBJECT system privilege.

Deleting a Domain

Database Version Domain Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
SAP Sybase IQ 16.0 Requires one of:
  • DROP DATATYPE system privilege.
  • DROP ANY OBJECT system privilege.
  • You own the domain.

Generating Domain DDL Commands

Database Version Domain Privileges
SAP Sybase IQ15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.

Viewing Domain Properties

Database Version Domain Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.
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