The

column list

argument specifies an optional list of columns in the table on which the SELECT, INSERT, or UPDATE privilege is being revoked. The column list, if specified, must be enclosed in parentheses, with each column name separated from the next by a comma.

These specify the name of an existing table/view, domain, or schema, respectively. If the table, view, or domain does not belong to the current schema, preface the object name with the schema name and a period ( . ), that is,

schema-name.object-name

. If privileges are being revoked from a schema or domain, the object type keyword (SCHEMA or DOMAIN) must be included before the object name. If no object type is specified, the target object is assumed to be a table or view, privileges are revoked from the table/view having the specified name.

The

user name

argument identifies one or more user authorization IDs (separated by commas) from which the specified privilege or privileges are being revoked. The PUBLIC keyword option can be specified along with or in place of an authorization ID (or a list of authorization IDs), revoking the specified privileges from all valid authorization IDs.