IDAX.REVOKE_MODEL - Revoke privileges on a model

Use this stored procedure to revoke privileges on a model from 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 revoke the SELECT privilege:
- CONTROL privilege on the model
- SECADM authority
To revoke the CONTROL privilege:
- SECADM authority

Note: Revoking of the CONTROL privilege revokes also the SELECT privilege.

IDAX.REVOKE_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.

If an error occurs, an exception is raised.