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

Thanks to all that replied.

SATURN is the name of my computer and I guess it was created during the Enterprise Manager install.

Zoran.

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:fxE_7.1$S63.102_at_inet-nntp1.oracle.com...
> Saturn is not one I've heard of before, but the reason Adams, Blake etc
are
> not there when you load the sample schemas is because we created new
sample
> schemas in 9i. One of the reasons for this is so we can use a consistent
> set of examples in our documentation and training. Another is because
it's
> damn hard to show the benefits of some of the functionality of the
database
> using the old demo accounts. Ever thought of how difficult it is to show
> partition pruning using EMP and DEPT? ;)
>
> --
> HTH. Additions and corrections welcome.
>
> Pete
> Author of "Oracle8i: Architecture and Administration Exam Cram"
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not. It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
>
> "Van Messner" <vmessner_at_bestweb.net> wrote in message
> news:u3k9h2lvrn2254_at_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 21 2002 - 22:52:25 CST