Sequence Generator Privilege Summary

Creating a Sequence Generator

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

Database Version	Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You own the sequence generator.
SAP Sybase IQ 16.0	Requires 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	Requires one of: DBA authority. You own the sequence generator.
SAP Sybase IQ 16.0	Requires 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 required.
SAP Sybase IQ 16.0	None required.

Database Version	Sequence Generator Permissions
SAP Sybase IQ 15.3 and 15.4	View sequence generator properties – None required. Modify a sequence comment – Requires one of: DBA authority. RESOURCE authority. You own the sequence generator. Modify sequence permissions – Requires one of: DBA authority. PERMS ADMIN authority. You own the sequence generator. Modify any other sequence property – Requires one of: DBA authority. You own the sequence generator.
SAP Sybase IQ 16.0	View any sequence property page – None required. Modify a sequence comment – Requires 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 – Requires one of: MANAGE ANY OBJECT PRIVILEGE system privilege. You own the sequence generator. Modify any other sequence property – Requires 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 required.

Modify a sequence comment – Requires one of:

Modify sequence permissions – Requires one of:

Modify any other sequence property – Requires one of:

SAP Sybase IQ 16.0

View any sequence property page – None required.

Modify a sequence comment – Requires one of:

Modify sequence permissions – Requires one of:

Modify any other sequence property – Requires one of:

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