DB__ROOT is unable to grant privilege on object in private schema

[Paul Low]

DB__ROOT user was able to create the object, but is not able to grant privileges on the object on behalf of the owner.

SQL>connect DB_ROOT_USERNAME1/DB_ROOT_PASSWORD1
Connected to Trafodion

SQL>create schema schema1 authorization USERNAME1;

--- SQL operation complete.

SQL>set schema schema1;

--- SQL operation complete.

SQL>create table tab1(a int, b int);

--- SQL operation complete.

SQL>grant select on tab1 to USERNAME2;

*** ERROR[1012] No privileges were granted. You lack grant option on the specified privileges.

[Cliff Gray (cliff-gray)]

In Trafodion DB__ROOT cannot grant (or revoke) object-level privileges on behalf of the user; the GRANTED BY option is part of the syntax but has not yet been implemented. When GRANTED BY is implemented, likely grants (and revokes) by DB__ROOT will be treated as a GRANTED BY on behalf of the object owner even if the GRANTED BY clause is not supplied.

[Roberta Marton (roberta-marton)]

When DB__ROOT executes a grant or revoke on objects it does not own, need to
  change the grantor from DB__ROOT to the object owner. This matches the same
  behavior for other DDL operations such as CREATE.

  As part of this fix, the GRANTED BY clause is now allowed for GRANT
  statements but it won't be complete until LP bug 1414225 is done.

[Paul Low (paul-low-x)]

verified on 0403 build