ORA-06598: insufficient INHERIT PRIVILEGES privilege
I get the below error while generating sqltxtract and sqltxplain analysis with sqltxadmin user and my session got disconnected and kicked me out !
BEGIN SQLTXADMIN.sqlt$i.xtract(p_statement_id => :v_statement_id, p_sql_id_or_hash_value => '1rzgj3atcc8vd', p_password => 'Y'); END;
*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SQLTXADMIN.SQLT$I", line 1
ORA-06512: at line 1
In case of a disconnect review log file in current directory
If running as SYS in 12c make sure to review sqlt_instructions.html first
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Solution: Ensure that you have connected to sqltxplain user and the sqlt users have following privileges to access the sqltx packages.
SQL>grant INHERIT ANY PRIVILEGES to sqltxadmin;
Grant succeeded.
SQL>grant INHERIT ANY PRIVILEGES to sqltxplain;
Grant succeeded.
SQL>grant SQLT_USER_ROLE to sqltxplain;
Grant succeeded.
SQL>grant SQLT_USER_ROLE to sqltxadmin;
Grant succeeded.
SQL> conn sqltxplain;
Enter password:
Connected.
SQL> START sqltxtract.sql 1rzgj3atcc8vd