Catalog Management functions fail when run by a Student user (W)

[afig]

Students cannot currently use describe or listTables. An error is reported stating that permission is denied for schema classdb. This is a result of PR #92, which added the use of the foldPgIDto those two functions. Since foldPgIDis in the classdbschema, the two functions in addCatalogMgnt.sql are now unusable by users who do not have access to the classdbschema (including Students).

Some form of foldPgID's behavior should still exist in those two functions, since it would be confusing for users if the function parameters were case-sensitive without quotes.

[smurthys]

Good find. Is the resolution granting execute to students on foldPgID?

[afig]

Unfortunately not, since students do not have any access to the classdb schema. We could either:

• Place foldPgID in a schema that is accessible by all users
• Define a new (otherwise identical) function for use specifically with addCatalogMgmt.sql
• Implement the behavior of foldPgID in listTables and describe.

[smurthys]

For now, it seems best to duplicate foldPgID in the two functions in question. If we proceed with this solution, I recommend adding clear comments where code is duplicated and also open an issue that code is duplicated (not for M1).