Return an empty resultset for getProcedures() when connected with a reader account

[SimbaGithub]

Overview from Snowflake support:

The customer is connecting to the Snowflake reader account via JDBC driver using their tool (name: Rhapsody). This tool performs schema discovery and calls the getProcedures() function when it establishes connectivity but since the Snowflake reader account doesn’t support it, it gets the error: “Operation not supported in Snowflake reader account”. Since this is failing the schema discovery process is getting interrupted.

SNOW-XXXXX

External contributors - please answer these questions before submitting a pull request. Thanks!

Please answer these questions before submitting your pull requests. Thanks!

1. What GitHub issue is this PR adressing? Make sure that there is an accompanying issue to your PR.

   Fixes #NNNN

2. Fill out the following pre-review checklist:

   • [ ] I am adding a new automated test(s) to verify correctness of my new code
   • [ ] I am adding new logging messages
   • [ ] I am modyfying authorization mechanisms
   • [ ] I am adding new credentials
   • [ ] I am modyfying OCSP code
   • [ ] I am adding a new dependency

3. Please describe how your code solves the related issue.

This change will return an empty result set instead of throwing an exception when calling getProcedures() with a reader account.

Pre-review checklist

• [ ] This change has passed precommit
• [ ] I have reviewed code coverage report for my PR in (Sonarqube)

[sonarqubemergegate[bot]]

SonarQube Quality Gate

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
No Duplication information

[sonarqubemergegate[bot]]

SonarQube Quality Gate

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
No Duplication information

[sonarqubemergegate[bot]]

SonarQube Quality Gate

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
No Duplication information