Sequence-Level Privileges

Although Informix® implements sequence objects as tables, only a subset of table-level privileges (page Table-Level Privileges) can be granted on a sequence. You can grant the Select or Alter privilege (or both) on a sequence:


Sequence-Level Privileges

                                              (1)               
|--+-ALL----------------+--ON--+--------+--+-------sequence-+---|
   | .-,--------------. |      '-owner.-'  '-synonym--------'   
   | V          (1)   | |                                       
   '---+-SELECT-----+-+-'                                       
       '-ALTER------'

Notes:

Informix extension

Element	Description	Restrictions	Syntax
owner	Owner of sequence (or owner of synonym)	Must be the owner	Owner name
sequence	Sequence on which to grant privileges	Must exist	Identifier
synonym	Synonym for a sequence object	Must exist	Identifier

The sequence object must exist in the current database. You can qualify the sequence or synonym identifier with a valid owner name, but the name of a remote database (or database@server) is not valid as a qualifier. You can include the WITH GRANT OPTION keywords when you grant ALTER, SELECT, or ALL to a user or to PUBLIC (but not to a role) as privileges on a sequence object.