Show TOC

REVOKE USAGE ON SEQUENCE StatementLocate this document in the navigation structure

Removes USAGE privilege on a specified sequence.

Syntax
REVOKE USAGE ON SEQUENCE <sequence-name>
   FROM <userID> [,...]
Parameters

(back to top)

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

(back to top)

  • SQL–syntax is a Persistent Stored Module feature.

  • SAP Database products–the security model is different in SAP ASE and SAP IQ, so other syntaxes differ.

Permissions

(back to top)

Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You own the sequence.