GRANT USAGE ON SEQUENCE Statement

Grants the USAGE system privilege on a specified sequence to a user or role.

Syntax

GRANT USAGE ON SEQUENCE sequence-name
   TO userID [,...]

Parameters

userID – must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.

Standards

SQL – syntax is a Persistent Stored Module feature.
Sybase – the security model is different in Adaptive Server Enterprise and SAP Sybase IQ, so other syntaxes differ.

Permissions

Requires one of:

MANAGE ANY OBJECT PRIVILEGE system privilege.
You own the sequence.

Parent topic: SQL Statements

Created May 22, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com