• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

What users and roles are created during Oracle SQLT installation

by admin

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

Filed Under: oracle

Some more articles you might also be interested in …

  1. Oracle GoldenGate: How to start Extract & Replicat using Shell Script
  2. Oracle Database 18c new feature – Scalable Sequences
  3. How to Start/Stop/Relocate SCAN listener in Oracle 11gR2 RAC
  4. How to Enable or Disable Veritas ODM for Oracle database 12.1.0.1
  5. ORA-00904: invalid identifier
  6. How to find current SQL statement being executed by particular session in Oracle
  7. Oracle Database: How to catalog tape backup pieces
  8. What are Command Rules in oracle Database
  9. How to Verify if a Disk/Partition is in Use by Oracle ASM, was used by Oracle ASM or is never used by Oracle ASM
  10. How to Connect to an Oracle Pluggable Database (PDB)

You May Also Like

Primary Sidebar

Recent Posts

  • grpck command – Remove corrupt or duplicate entries in the /etc/group and /etc/gshadow files.
  • xxd command – Expressed in hexadecimal form
  • sesearch: command not found
  • macof: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright