Thanks for the question, abhishek.
Asked: May 06, 2020 - 3:46 am UTC
Last updated: May 09, 2020 - 12:36 am UTC
Version: Oracle 11g 11.2.0.1.0
Viewed 1000+ times
You Asked
Hi,
Can I reomove/ drop the below users from Production DB (Oracle 11g):
ANONYMOUS,
APEX_030200,
APEX_PUBLIC_USER,
APPQOSSYS,
CTXSYS,
DIP,
EXFSYS,
FLOWS_FILES,
MDDATA,
MDSYS,
OLAPSYS,
ORACLE_OCM,
ORDDATA,
ORDPLUGINS,
ORDSYS,
OUTLN,
OWBSYS,
OWBSYS_AUDIT,
SCOTT,
SPATIAL_CSW_ADMIN_USR,
SPATIAL_WFS_ADMIN_USR,
WMSYS,
XDB,
XS$NULL
The Production DB (Oracle 11g) has been running since around 8 years. Can I change the below users password without affecting the normal functioning of the DB?
SYS, SYSTEM, SYSMAN, DBSNMP, SI_INFORMTN_SCHEMA, MGMT_VIEW
and Chris said...
Most of these look like predefined accounts. You can find a list of these and their purpose in the docs:
https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_user_accounts.htm#TDPSG20030 To decide if you can remove an account, you need to verify you're not using the associated features.
Can I change the below users password without affecting the normal functioning of the DB?You tell me!
In theory you should be able to change these passwords. But you need to be sure that you update the credentials for any applications and scripts that connect as these users.
Chances are after 8 years there are at least one or two scripts knocking around that you're not aware of.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment