Usage Privilege in Stored Procedure Language

The Usage privilege on SPL is granted to PUBLIC by default. Only user informix, the DBA, or a user who was granted the Usage privilege WITH GRANT OPTION can grant the Usage privilege on SPL to another user.

In the following example, assume that the default Usage privilege on SPL was revoked from PUBLIC and the DBA wants to grant the Usage privilege on SPL to the role named developers:

Sequence-Level Privileges (IDS)

Although Dynamic Server 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:
 
|--+-ALL-----------------+--ON--+--------+---------------------->
   | .-,---------------. |      '-owner.-'
   | V          (1)    | |
   '---+-SELECT------+-+-'
       '-ALTER-------'
 
      (1)
>--+--------sequence-+------------------------------------------|
   '-synonym---------'

Notes:

Informix extension

Element	Description	Restrictions	Syntax
owner	Owner of sequence (or owner of synonym)	Must be the owner	Owner Name, p. Owner Name
sequence	Sequence on which to grant privileges	Must exist	Identifier, p. Identifier
synonym	Synonym for a sequence object	Must exist	Identifier, p. 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.