GRANT (Model)
Grants usage privileges on a model to users and roles.
Syntax
GRANT { privilege[,...] | ALL [ PRIVILEGES ] [ EXTEND ] } ON MODEL [[database.]schema.]model‑name[,...] TO grantee[,...] [ WITH GRANT OPTION ]
Parameters
privilege |
The following privileges are valid for models: |
ALL [PRIVILEGES][EXTEND]
|
Grants all model privileges that also belong to the grantor. Grantors cannot grant privileges that they themselves lack. You can qualify
|
[database.]schema
|
Database and schema. The default schema is |
model‑name |
The model on which to grant the privilege. |
grantee |
Specifies who is granted privileges, one of the following: |
WITH GRANT OPTION
|
Gives grantee the privilege to grant the same privileges to other users or roles, and also revoke them. For details, see Granting Privileges. |
Privileges
Non-superusers require USAGE on the schema and one of the following:
- Owner
- Privileges grantee given the option (
WITH GRANT OPTION
) of granting privileges to other users or roles.
Example
This example grants USAGE privileges on the mySvmClassModel model to user1:
=> GRANT USAGE ON MODEL mySvmClassModel TO user1;