DB2 Version 9.7 for Linux, UNIX, and Windows

GrantorList CLI/ODBC 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' "
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 quotes, and separated by commas. The entire string must also be enclosed in double quotes. For example:

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

In the above 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.