you could always exp the user and drop it... or whatever you'd like to do (generate scripts, etc) to backup whatever the schema owns. I've, for one, have never heard of it. Lyall -----Original Message----- From: Ingrid Voigt <giantpanda@xxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Thu, Oct 15, 2009 10:52 am Subject: Database User LIB Hi, we've found a user named LIB in one of our production ystems (9.2.0.7 EE on Windows) and have no idea where e came from (created after the database and the application chemas) or what he is used for. The customer and pplication developer do not know this user either. Nobody connected as LIB in the last few weeks, but here are things that run only rarely. The schema holds no objects, the create script is REATE USER LIB IDENTIFIED BY PASSWORD MEDIA DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP2 PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for LIB GRANT CONNECT TO LIB; GRANT RESOURCE TO LIB; GRANT SELECT_CATALOG_ROLE TO LIB; ALTER USER LIB DEFAULT ROLE ALL; -- 2 System Privileges for LIB GRANT SELECT ANY TABLE TO LIB; GRANT UNLIMITED TABLESPACE TO LIB; Does anybody know if this is an Oracle default schema or some special purpose? Any other idea how to identify ts purpose other than waiting for a year or so? We would like to drop this user if it can be done without ny damage. hank you ngrid - RATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! etzt freischalten unter http://portal.gmx.net/de/go/maxdome01 - ttp://www.freelists.org/webpage/oracle-l