Privlege issue on inser/select of xmlcolumn and object/relational storag
I have a user with xdbadmin privilege.
That user has a table with a column defined with object relational storage using annotated xsd. The xsd resource is registered. The xml schema based on that xsd is registered. The user performed the registration processes. The underlying Tables and object types defined in the xsd create successfully. The table with the xmlcolumn is created successfully. If I connect as sys, I can insert into the table and select from it successfully. If I try to insert or select as the table_owner or anyone else, it fails with an ora-28113.
The xml schema is associated with the all_all_acl.xml.
The error message in the trace file looks to be associated with a call to xdb.dbms_xdbz0.checkworkspace_pf. It looks like the root of the problem is an ORA-00904 error with 'sys_in_workspace": invalid identifier. This looks like a permission issue.
Currently they have connect, resource, xdbadmin and dba. Even with that, only sys can use it.
Did I miss a step in setting up the user to use xdb?