GrantorFilter IBM data server driver configuration keyword
Reduces the amount of information that is returned when the application gets a list of table or column privileges.
- Equivalent CLI keyword
- GrantorList
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="GrantorFilter" value="'userID1','userID2', ... 'userIDn"/>- Default setting:
- Do not filter the results.
- Usage notes:
-
The list of authorization IDs specified is used as a filter. The only tables or columns with privileges granted BY the listed IDs are returned.
Set the GrantorFilter keyword to a list of one or more authorization IDs that granted privileges, delimited with single quotation marks, and separated by commas. For example:<parameter name="GrantorFilter" value="'USER1','USER2','USER8'"/>In the preceding 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.