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.