GRANT (Model)
Grants access to models to a database user or role.
Syntax
GRANT {ALL | USAGE } ... ON MODEL [ [ db-name.]schema.]modelname [ , ... ] ... TO { username | role | PUBLIC} ... [ WITH GRANT OPTION ]
Parameters
ALL | USAGE |
Applies to all privileges. |
[db-name.]schema.database-name |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema |
username] role ] PUBLIC |
The name of the user, role or group to be granted access. |
WITH GRANT OPTION |
Allows the user to grant the same privileges to other users. |
Example
This example grants USAGE privileges on the mySvmClassModel model to user1:
=> GRANT USAGE ON MODEL mySvmClassModel TO user1;