Sequence Generator Privilege Summary

Creating a Sequence Generator

Database Version	Sequence Generator 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 ANY SEQUENCE system privilege CREATE ANY OBJECT system privilege

Database Version	Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the sequence generator
SAP Sybase IQ 16.0	You must have one of: DROP ANY SEQUENCE system privilege DROP ANY OBJECT system privilege You own the sequence generator

Database Version	Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the sequence generator
SAP Sybase IQ 16.0	You must have one of: ALTER ANY SEQUENCE system privilege ALTER ANY OBJECT system privilege You own the sequence generator

Database Version	Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4	None.
SAP Sybase IQ 16.0	None.

Database Version	Sequence Generator Permissions
SAP Sybase IQ 15.3 and 15.4	View sequence generator properties – none. Modify a sequence comment – you must have one of: DBA authority RESOURCE authority You own the sequence generator Modify sequence permissions – You must have one of: DBA authority PERMS ADMIN authority You own the sequence generator Modify any other sequence property – you must have one of: DBA authority You own the sequence generator
SAP Sybase IQ 16.0	View any sequence property page – none. Modify a sequence comment – you must have one of: CREATE ANY SEQUENCE system privilege ALTER ANY SEQUENCE system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege Modify sequence permissions – You must have one of: MANAGE ANY OBJECT PRIVILEGE system privilege You own the sequence generator Modify any other sequence property – you must have one of: ALTER ANY SEQUENCE system privilege ALTER ANY OBJECT system privilege You own the sequence generator

Database Version

Sequence Generator Permissions

SAP Sybase IQ 15.3 and 15.4

View sequence generator properties – none.

Modify a sequence comment – you must have one of:

Modify sequence permissions – You must have one of:

Modify any other sequence property – you must have one of:

SAP Sybase IQ 16.0

View any sequence property page – none.

Modify a sequence comment – you must have one of:

Modify sequence permissions – You must have one of:

Modify any other sequence property – you must have one of:

Database Version	Database Object Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority PERMS ADMIN authority You own the sequence generator
SAP Sybase IQ 16.0	You must have one of: MANAGE ANY OBJECT PRIVILEGE system privilege You own the sequence generator