c-treeACE V10.0 Release Notes

Proper Authorization When Using Table Alias

Queries from derived tables could throw an authorization error when a set schema was issued.

SET SCHEMA 'admin';

SELECT cm_custnum FROM (SELECT * FROM custmast) AS custno

error(-20228): Access denied(Authorisation failed)

While authorization was attempted on derived tables (aliased tables/query result), authorization information is not applied to these types of tables. The check is now skipped for these table types preventing this error.