In a 12c database, when selecting an object from Schema Browser (tables or procedures selection gets same error), the following error occurs:
"ORA-06598: insufficient INHERIT PRIVILEGES privilege"
which requires the 'OK' be pressed to continue.
On reviewing the output from SQL Tracker, the error is occurring when the following is run (it is executed multiple times in the tracker):
BEGIN
IF qu_toad_api.num_tds_for_program(USER, :owner, :name) <> 0
THEN
:retval := 1;
ELSE
:retval := 0;
END IF;
END;
Error occurred: [6598] (ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYSTEM.QU_TOAD_API", line 1
ORA-06512: at line 2
)
In what scenario would this code get run?