I log in as my own schema and open up a table from the Navigation Manager owned by a different schema. When I try to access the script in the Script Tab I get the following error:
ORA-31603: object <table> of type TABLE not found in schema <Schema> ORA-06512: at SYS.DBMS_SYS_ERROR,;
line 105 ORA-06512: at SYS.DBMS_METADATA,;
line 2805 ORA-06512: at SYS.DBMS_METADATA,;
line 4333 ORA-06512: at line 1;
The login schema has DBA role.
Issue is related to this query that TDA runs:
SELECT DBMS_METADATA.GET_DDL(<object type>,<object name>, <schema>) Text from dual;
WORKAROUND 1:
Grant SELECT_CATALOG_ROLE as a Default grant. This grant must be defaulted and just granting SELECT_CATALOG_ROLE will not be sufficient.
GRANT SELECT_CATALOG_ROLE to <schema>;
ALTER USER<schema> DEFAULT ROLE SELECT_CATALOG_ROLE;
WORKAROUND 2:
If granting SELECT_CATALOG_ROLE is not doable,then grant ALL privileges of individual table to the schema.
GRANTSELECT ON<table> TO <schema>;
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center