Added privilege manager upgrade support Recently, column level privileges has been delivered which requires new metadata tables. This delivery changes Trafodion upgrade to create the new metadata tables in preparation for a future upgrade in release 2.0. The version number has not changed.
Security bug fixes Corrects a number of bugs in security and SQL DDL. 1. 1439316: Internal error when creating view with sequence. 2. 1441825: User in role-owned schema is not given grant option. 3. 1447328: DB__ROOT required to revoke component privileges by other users. 4. 1447330: DB__ROOT required to revoke object and column privileges granted by other users.
In addition, Launchpad bugs 1350627 and 1438886 were tested and found to no longer be a defect.
Two new component-level privileges were added, MANAGE and MANAGE_PRIVILEGES.
Users who have the MANAGE_PRIVILEGE component-level privilege can grant and revoke privileges at the schema, object, and column level on behalf of other users and roles. Users who have the MANAGE_PRIVILEGE component-level privilege can also grant "WITH GRANT OPTION" any privilege they have.
A user granted the MANAGE privilege has all the MANAGE_* privileges, which includes MANAGE_COMPONENTS, MANAGE_LIBRARY, MANAGE_LOAD, MANAGE_PRIVILEGES, MANAGE_ROLES, MANAGE_STATISTICS, and MANAGE_USERS.