This content has been marked as final. Show 5 replies
But what happens if I change its password?what SQL would you issue to accomplish this change?
Will some functionality break?After you change it, report back what you learned.
what SQL would you issue to accomplish this change?AFAIK there's two ways to change a password, either use "alter user identified by" or insert the hashed password into sys.usesr$ (in 11g you need both DES and SHA-1 hashes). You could easily guess which one I pick.
After you change it, report back what you learned.I will change it after I learn what will happen.
FYI, Reply from Oracle Support:
"If you do this then the XS feature will not work anymore. Please do not change the password of this user."
Ok! Thanks for this help, but... what is this XS feature?
XS$NULL have no any objects in XE 11g R2default installation. Checked from obj$ with owner#=2147483638.
Excluded from normal export and datapump export.
Excluded from Data Guard Logical Standby activity monitoring support.
Hidden any future objects from all sys views.
XS$NULL related with XDB schema list.
Database contain some XSD under /xs/
Oracle rdbms SQLs talk about Fusion and Security.
Maybe some advanced security option from Fusion Middleware...
Oh, and I found a little mispelling in /xs/roleset.xsd:
Register XS Role SEt schema"
"Set" typed as "SEt" :)