XDB -XML DB

The XDB account is a locked account and should remain a locked account.. Under normal circumstances no new objects should be created in the XDB account, doing so could have very unfortunate and predictable side-effects during patching installation or during upgrade or downgrade. The priviliges needed, can be granted via the XDB roles (eg. XDBADMIN) or set via using ACL's (see XDB dev. Guide).

 Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it

We can check if  its being used internally or otherwise using (srdc_xdbinfosql.html ),as we dont see any user created XMls, so it's internally used and can safely lock the account .

Alter user would suffice to change the user credentials.

List of XMLType tables and tables with XMLType columns ************************************************************************* OWNER TABLE_NAME STORAGE_TYPE XMLSCHEMA -------------------- ---------------------------- -------------------- --------------------------------------------------------------------------- XDB XDB$ACL BINARY http://xmlns.oracle.com/xdb/acl.xsd XDB XDB$ALL_MODEL OBJECT-RELATIONAL http://xmlns.oracle.com/xdb/XDBSchema.xsd XDB XDB$ANY OBJECT-RELATIONAL http://xmlns.oracle.com/xdb/XDBSchema.xsd XDB XDB$ANYATTR OBJECT-RELATIONAL http://xmlns.oracle.com/xdb/XDBSchema.xsd XDB XDB$ATTRGROUP_DEF OBJECT-RELATIONAL http://xmlns.oracle.com/xdb/XDBSchema.xsd XDB XDB$ATTRGROUP_REF OBJECT-RELATIONAL http://xmlns.oracle.com/xdb/XDBSchema.xsd and many more