REVOKE (Model)

Revokes privileges on a model from a user or role.

Syntax

REVOKE { ALL | USAGE } 
... ON MODEL [ [ db-name.]schema.]modelname [ , ... ]
... FROM { username  | role  | PUBLIC} [ , ... ]
... [ CASCADE ]

[[db-name.]schema]	Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema
modelname	Specifies the model from which to remove privileges.
username] role ] PUBLIC	The name of the user, role or group to be granted access.
CASCADE	Revokes the privilege from the specified user or role and then from others. After a user or role has been granted a privilege, the user can grant that privilege to other users and roles. The CASCADE keyword first revokes the privilege from the initial user or role, and then from other grantees extended the privilege.

This example revokes user1's USAGE privilege on the mySvmClassModel model:

=> REVOKE USAGE ON mySvmClassModel FROM user1;