Re: Who are ADAMS, BLAKE, CLARK, JONES Oracle users?

From: Van Messner <vmessner_at_bestweb.net>
Date: Mon, 7 Jan 2002 17:45:12 -0500
Message-ID: <u3k9h2lvrn2254@corp.supernews.com>

This is interesting. I never do typical installs so these are new to me. I did install the samples in 9i but didn't get these users. I took a look at the 9i sql.bsq which is the only one I have here and there is no reference to utlsampl.sql, so I wonder where it's called from?

utlsampl.sql is below - so what about Saturn?

Rem Copyright (c) 1990, 1996, 1997, 1999, 2001 by Oracle Corporation Rem NAME
REM UTLSAMPL.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED

Rem     menash     02/21/01 -  remove unnecessary users for security reasons
Rem     gwood      03/23/99 -  make all dates Y2K compliant
Rem     jbellemo   02/27/97 -  dont connect as system
Rem     akolk      08/06/96 -  bug 368261: Adding date formats
Rem     glumpkin   10/21/92 -  Renamed from SQLBLD.SQL
Rem     blinden   07/27/92 -  Added primary and foreign keys to EMP and DEPT
Rem     rlim       04/29/91 -         change char to varchar2
Rem     mmoore     04/08/91 -         use unlimited tablespace priv
Rem     pritto     04/04/91 -         change SYSDATE to 13-JUL-87

Rem Mendels 12/07/90 - bug 30123;add to_date calls so language independent
Rem
rem
rem $Header: utlsampl.sql 21-feb-01.18:15:30 menash Exp $ sqlbld.sql rem
SET TERMOUT OFF
SET ECHO OFF rem CONGDON Invoked in RDBMS at build time. 29-DEC-1988 rem OATES: Created: 16-Feb-83

DROP USER SCOTT CASCADE;
DROP USER ADAMS CASCADE;
DROP USER JONES CASCADE;
DROP USER CLARK CASCADE;
DROP USER BLAKE CASCADE;

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER; DROP PUBLIC SYNONYM PARTS; CONNECT SCOTT/TIGER
CREATE TABLE DEPT
       (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,  DNAME VARCHAR2(14) ,
 LOC VARCHAR2(13) ) ;
CREATE TABLE EMP
       (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,  ENAME VARCHAR2(10),
 JOB VARCHAR2(9),
 MGR NUMBER(4),
 HIREDATE DATE,
 SAL NUMBER(7,2),
 COMM NUMBER(7,2),
 DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT); INSERT INTO DEPT VALUES
 (10,'ACCOUNTING','NEW YORK');
INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS'); INSERT INTO DEPT VALUES
 (30,'SALES','CHICAGO');
INSERT INTO DEPT VALUES
 (40,'OPERATIONS','BOSTON');
INSERT INTO EMP VALUES
(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);
INSERT INTO EMP VALUES
(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30)
;
INSERT INTO EMP VALUES
(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);
INSERT INTO EMP VALUES
(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);
INSERT INTO EMP VALUES
(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,3
0);
INSERT INTO EMP VALUES
(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);
INSERT INTO EMP VALUES
(7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);
INSERT INTO EMP VALUES
(7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3000,NULL,20
);
INSERT INTO EMP VALUES
(7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,1
0);
INSERT INTO EMP VALUES
(7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);
INSERT INTO EMP VALUES
(7876,'ADAMS','CLERK',7788,to_date('13-JUL-87',
'dd-mm-rr')-51,1100,NULL,20);
INSERT INTO EMP VALUES
(7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);
INSERT INTO EMP VALUES
(7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);
INSERT INTO EMP VALUES
(7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);
CREATE TABLE BONUS
 (
 ENAME VARCHAR2(10) ,
 JOB VARCHAR2(9) ,
 SAL NUMBER,
 COMM NUMBER
 ) ;
CREATE TABLE SALGRADE
      ( GRADE NUMBER,
 LOSAL NUMBER,
 HISAL NUMBER );

INSERT INTO SALGRADE VALUES (1,700,1200);
INSERT INTO SALGRADE VALUES (2,1201,1400);
INSERT INTO SALGRADE VALUES (3,1401,2000);
INSERT INTO SALGRADE VALUES (4,2001,3000);
INSERT INTO SALGRADE VALUES (5,3001,9999);

COMMIT;
EXIT "Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:iip_7.3033$lt4.144513_at_ozemail.com.au...

>
> "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3C378C3B.34ADD0BD_at_exesolutions.com...
> > NEver seen all ADAMS, BLAKE, CLARK, and SATURN after many 8i installs. I
> suspect
> > you have something/someone else meddling about. The others are used by
> options
> > you, or someone else, installed.
> >
>
> ADAMS, BLAKE, CLARK and JONES, are created during install by the
> utlsampl.sql in the rdbms/admin directory, as part of the demo stuff.  All
> my "typical" installs have them.  I just drop them as they seem to be of

no

> use. I have no idea which part of the install creates them.
>
> Regards
>
> Ray
>
> > Dan Morgan
> >
> >
> >
> > Zoran Marjanski wrote:
> >
> > > This may seem like a silly question but my curiosity has gotten the

best

> of
> > > me.
> > >
> > > In 8i there are a bunch of extra Oracle Users created during
> installation. I
> > > know about SCOTT, the sample schema, but who are the rest and what are
> > > they're passwords? Are they just other sample SCOTT's, but they don't
> have
> > > any database objects with them.
> > >
> > > What about the rest of them? Are these documented somewhere?
> > >
> > > ADAMS    ?
> > > AURORA$JIS$UTILITY$    Java?
> > > AURORA$ORB$UNAUTHENTICATED    Java?
> > > BLAKE    ?
> > > CLARK    ?
> > > CTXSYS    ?
> > > DBSNMP    Used for SNMP?
> > > DES6I        Used by Designer 6i
> > > JONES    ?
> > > MDSYS    ?
> > > MTSSYS    ?
> > > ORDPLUGINS    ?
> > > ORDSYS    ?
> > > OSE$HTTP$ADMIN    Something to do with administration via http?
> > > OUTLN    ?
> > > SATURN    Used by OEM
> > > SCOTT        I know about this one
> > > SYS            I know about this one
> > > SYSTEM    I know about this one
> > >
> > > Thanks, Zoran.
> >
>
>

Received on Mon Jan 07 2002 - 16:45:12 CST