GrantorList CLI/ODBC and IBM data server driver configuration keyword

Reduces the amount of information returned when the application gets a list of table or column privileges.

db2cli.ini keyword syntax:: GrantorList = " 'userID1', 'userID2',... 'userIDn' "
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:: <parameter name="GrantorList" value=" 'userID1', 'userID2',... 'userIDn'"/>

Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.

Default setting:: Do not filter the results.
Usage notes:

This option can be used to reduce the amount of information returned when the application gets a list of privileges for tables in a database, or columns in a table. The list of authorization IDs specified is used as a filter; the only tables or columns that are returned are those with privileges that have been granted BY those IDs.

Set this option to a list of one or more authorization IDs that have granted privileges, delimited with single quotation mark, and separated by commas. The entire string must also be enclosed in double quotation marks. For example:

 
    GrantorList=" 'USER1', 'USER2', 'USER8' "

In the example, if the application gets a list of privileges for a specific table, only those columns that have a privilege granted BY USER1, USER2, or USER8 would be returned.