Database User LIB
Date: Thu, 15 Oct 2009 16:52:26 +0200
we've found a user named LIB in one of our production systems (18.104.22.168 EE on Windows) and have no idea where he came from (created after the database and the application schemas) or what he is used for. The customer and application developer do not know this user either.
Nobody connected as LIB in the last few weeks, but there are things that run only rarely.
The schema holds no objects, the create script is
CREATE USER LIB
IDENTIFIED BY PASSWORD MEDIA
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP2
- 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;
We would like to drop this user if it can be done without any damage.
-- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 15 2009 - 09:52:26 CDT