During the installation of this SQLT tool, 2 users and one role are created. These users and role have fixed names.
The SQLT repository is owned by user SQLTXPLAIN. SQLT users need to provide the SQLTXPLAIN password everytime they use any of the main methods. User SQLTXPLAIN is granted the following system privileges:
CREATE SESSION CREATE TABLE
The SQLT set of PL/SQL packages and Views is owned by user SQLTXADMIN. This SQLTXADMIN user is locked and identified by a random password. SQLTXADMIN is granted the following system privileges:
ADMINISTER SQL MANAGEMENT OBJECT ADMINISTER SQL TUNING SET ADVISOR ALTER SESSION ANALYZE ANY SELECT ANY DICTIONARY SELECT_CATALOG_ROLE
All SQLT users must be granted the SQLT_USER_ROLE before they can use any of the main methods. This SQLT_USER_ROLE role is granted the following system privileges:
ADVISOR SELECT_CATALOG_ROLE
It’s not possible to use SYS as SQLT user by default in 12c due to a change in the security model for PL/SQL. To address this change SQLTXADMIN needs to be granted INHERIT PRIVILEGES on SYS.
GRANT INHERIT PRIVILEGES ON USER SYS TO SQLTXADMIN