IDAX.GRANT_MODEL - Grant a privilege on a model

Use this stored procedure to grant a privilege on a model to one or more users, groups, or roles.

You must specify at least one user, one group, or one role. You can specify also the PUBLIC group. The PUBLIC group includes all users.

Authorities

The privileges held by the authorization ID of the statement must include at least one of the following authorities.

To grant the SELECT privilege:
- CONTROL privilege on the model
- SECADM authority
- SELECT WITH GRANT OPTION privilege
To grant the CONTROL privilege:
- SECADM authority

IDAX.GRANT_MODEL(in parameter_string varchar(32672))

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

model: Mandatory.; Name of the model, which the privilege is given for.
privilege: Mandatory.; SELECT or CONTROL.
user: Optional.; A list of names of users who get the privilege. The user names must be separated by semicolons.
group: Optional.; A list of names of groups who get the privilege. The group names must be separated by semicolons.
role: Optional.; A list of names of roles that get the privilege. The role names must be separated by semicolons.
grantoption: Optional.; Default: false.; If grantoption=true, the users, groups, or roles are allowed to grant the privilege to others.

If an error occurs, an exception is raised.