[TRAFODION-1882]: Column Privilege: a user can grant column privilege to ... [TRAFODION-1788]: Grant and Revoke on table columns with referencing views ...
[TRAFODION-1882]: Column Privilege: a user can grant column privilege to ...
[TRAFODION-1788]: Grant and Revoke on table columns with referencing views ...

This delivery fixes several issues related to object and columnn privileges.
This should fix remaining issues with column level privileges so we can
officially support them.

-- When creating views, column level privileges were only considered if the
   SELECT privilege was not found at the object level.  Column level privs are
   now always considered, if the view owner has a privilege on all the columns
   that make up the view, then the view is granted the privilege.

-- When granting or revoking privileges, the code needs to verify if a user has
   a privilege at the column level.  In order to to this, the code needs the
   view-col <=> referenced-col usages.  This information is current not
   available.  Create view was changed to add view-col <=> referenced-col usages
   to the TEXT table.  This allows NATable and privilege management to retrieve
   this information. Views created prior to the change will not allow column
   privileges to be granted.  These views have to be dropped and recreated.

-- Grants and revokes on referenced columns for objects are now  propagated to
   to referencing view.  Propagation is performed to the immediate child views
   only.

-- Added some code to prepare for CASCADE.  This code processes the chain of
   views that exist looking for objects that may be affected by the grant or
   revoke.

-- The DB__ROOT user can perform operations on behalf on the schema owner.
   There were some situations where privileges were based on DB__ROOT instead
   of the schema_owner.  So a user that should not be granted a privileges was
   granted the privileges.  Changes were made to make sure the schema owner
   privileges were used in this situation.

-- Fixed an issue during column grants where column ordinals were not checked
   for views that reference an object.

-- Fixed an issue where insertable view info was not set up properly.

-- Fixed a problem where role usages was not considered when getting the list
   correctly [TRAFODION-1882]

-- Add new regression test privs2/TEST143 and moved the view propagation
   test from privs1/TEST141 to TEST143.

mashengchen/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,mashengchen/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion,rlugojr/incubator-trafodion,rlugojr/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion,mashengchen/incubator-trafodion