Good morning,
This question is related to another question I asked earlier about policy violations. As a result of the following users:
APEX_030200
OWBSYS_AUDIT
OWBSYS
APPQOSSYS
being assigned to the default table space of SYSAUX, EM reports a violation stating that these users should not have that tablespace as their default tablespace.
Because of that, I reassigned the default tablespace for those users to be the USERS tablespace. That looked like it was the right decision until Aman mentioned that these users are not quite "normal" users and they probably shouldn't be in the USERS tablespace.
The question: What default tablespace do I assign to these users ? If I leave them in the SYSAUX, I will have EM report a policy violation. If I reassign them to the USERS tablespace, this apparently is not the best thing to do either. What is the right default tablespace to assign to these users (should I create a tablespace for these users ?) ? (Preferably one that would satisfy EM if possible). How have other DBAs dealt with this "problem" in their installations ?
Thank you for your help,
John.