GitHub user robertamarton opened a pull request: https://github.com/apache/trafodion/pull/1703
Only expose supported component operations There is a set of component operations and many are about features that we do not support such as CREATE_TRIGGER. This checkin no longer returns these privileges through get privileges on component sql_operations showddl component sql_operations The is_system metadata column in the component_operations table now supports three values: Y - it is a system operation N - it is a user operation U - it is an unsupported (unused) operation (new) An "initialize authorization" or fresh installation is required to make these changes available. Installating this code version calls initialize authorization Running regrinit.sql also calls initialize authorization Some performance enhancements were made to make "initialize authorization" run faster. You can merge this pull request into a Git repository by running: $ git pull https://github.com/robertamarton/incubator-trafodion comp-privs Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1703.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1703 ---- commit 88ed0582c7e09c51acc924735031806210968675 Author: Roberta Marton <roberta.marton@...> Date: 2018-08-24T22:29:06Z Only expose supported component operations There is a set of component operations and many are about features that we do not support such as CREATE_TRIGGER. This checkin no longer returns these privileges through get privileges on component sql_operations showddl component sql_operations The is_system metadata column in the component_operations table now supports three values: Y - it is a system operation N - it is a user operation U - it is an unsupported (unused) operation (new) An "initialize authorization" or fresh installation is required to make these changes available. Installating this code version calls initialize authorization Running regrinit.sql also calls initialize authorization Some performance enhancements were made to make "initialize authorization" run faster. ---- ---