Toad for Db2 LUW
Following the recommendations of the CIS Center for Internet Security for Benchmark, I have proceeded to revoke the public permissions of several views of the SYSCAT schema, for example: REVOKE SELECT ON SYSCAT.SCHEMATA FROM PUBLIC. After this, when browsing the Toad object explorer, I had some display errors and proceeded to grant permissions to a group on a few views where the permission error was very clear, for example: GRANT SELECT ON SYSCAT.SCHEMATA TO GROUP AUDITORIA;
Now, when I want to see the script for generating the stored procedures and functions, I get the following error message: Permissions are absent in the script due to errors. See exception log for details. But there are no more details about which permission is missing.
What view or table function does Toad use to display the DDL in the script tab of the procedures and functions?