Unable to create view using table on private schema

[Paul Low]

db__root creates private schema with authorization to another user.
db__root creates table and has SELECT privilege.
db__root is unable to create view selecting from table.

SQL>create private schema pri_sch32 authorization USERNAME1;

--- SQL operation complete.

SQL>set schema pri_sch32;

--- SQL operation complete.

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

--- SQL operation complete.

SQL>select * from tab1;

--- 0 row(s) selected.

SQL>insert into tab1 values (1,1);

--- 1 row(s) inserted.

SQL>create view view1 as select * from tab1;

*** ERROR[4481] The user does not have SELECT privilege on table or view TRAFODION.PRI_SCH32.TAB1.

SQL>

[Cliff Gray (cliff-gray)]

Currently only considering explicit object-level privileges when deciding if a user has the authority to access the table(s) and view(s) referenced by the view to be created. This will be fixed soon.