What is user/owner CTXSYS and MDSYS in Oracle

  • 23 November 2021
  • 2 replies

Userlevel 4
Badge +9

I am try to figure out what user/owner CTXSYS and MDSYS are used by for in Oracle19?

Are they needed?



Best answer by Kasun Balasooriya 24 November 2021, 12:12

View original

2 replies

Userlevel 7
Badge +14

Hi @arebbeadle ,

Both of these users are oracle users/owners and utilized by oracle for specific functionalities. 

According to oracle documentation

17.1.1 CTXSYS User

The CTXSYS user is created during installation and can:

  • View all indexes

  • Sync all indexes

  • Run ctxkbtc, the knowledge base extension compiler

  • Query all system-defined views

  • Perform all tasks of a user with the CTXAPP role

MDSYS owns  Oracle Spatial objects. You can read more about these objects in this doc. Also refer this document for changes in oracle 19C for  Oracle Spatial objects and MDSYS. 

Hope this helps!





Userlevel 4
Badge +9

Thank you,