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 |
You must have one of:- DBA authority
- RESOURCE authority
|
| SAP Sybase IQ
16.0 |
You must have 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 |
You must have DBA
authority. |
| SAP Sybase IQ
16.0 |
You must have 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. |
| SAP Sybase IQ
16.0 |
None. |
Viewing Domain Properties
| Database Version |
Domain Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
None. |
| SAP Sybase IQ
16.0 |
None. |