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
Creating a Domain
Deleting a Domain
Generating Domain DDL Commands
Viewing Domain Properties