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

Published by kishan

You will know about me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: