You can use function mapping to hide credentials in an authorization object. After you create the function mapping, you can use the mapped authorization object in queries and avoid exposing your credentials.
The user needs the following privileges to create an authorization object and a function mapping. Contact your administrative user for assistance
- CREATE AUTHORIZATION privilege to create an authorization object
- CREATE FUNCTION privilege to create a function mapping
You can define a function mapping for the READ_NOS function with the EXTERNAL SECURITY clause to include an authorization. You can also define a function mapping which includes the ANY IN TABLE clause for querying files without an extension.