Install Space Manager Server Objects failed with ORA-01031 insufficient privileges. (4335579)

Space manager oracle user already has dba role, and Oracle’s O7_DICTIONARY_ACCESSIBILITY initialization parameter is set to true. However, space manager tries to install server side object on Oracle 12C, and it will fail with 01031 insufficient privileges when it tries to create view quest_spc_all_obj.  

dba role in 12c does not have select privileges on sys.user$ and create view quest_spc_all_obj will try to query from sys.user$

 SQL> connect testdbarole/<password>@tnguyen
Connected.
SQL> select * from sys.user$;
select * from sys.user$
                  *
ERROR at line 1:
ORA-01031: insufficient privileges

grant select on sys.users to <space_manager_user>;

Install server side object again.