IDAX.LIST_PRIVILEGES - List privileges on all models

Use this stored procedure to list the privileges of a user on all models. The list applies to all models for which you have the authorization to generate a list.

Only effective privileges, such as SELECT or CONTROL, are listed. Individual privileges, such as user privileges, group privileges, or role privileges are not listed.

Authorities

None required.

Syntax

IDAX.LIST_PRIVILEGES(in parameter_string varchar(32672))

Parameter descriptions

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:
user
Optional.
The name of the user whose privileges are to be listed.
If you do not specify a user name, the privileges of the session user are listed.
Users can list only their own privileges. To list privileges of another user, SECADM authority is required. Therefore, do not specify the user parameter if you do not have SECADM authority.

Returned information

A list of all effective privileges as a result set.

The result set contains the following columns:

  • MODELSCHEMA
  • MODELNAME
  • USERNAME
  • PRIVILEGES