Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbca question
No the sample schemas are new in 9i (account names like HR, QS and so on).
SCOTT was the old demo account and is still there for you if you want to use
EMP and DEPT. But there's a lot of Oracle functionality you can't really
see properly using EMP and DEPT (partitioning springs to mind as an obvious
example). SCOTT is left unlocked because it is actually used to prove the
database creation worked correctly, presumably by selecting from EMP or some
such thing. Not sure if this is done in the DBCA or partner stuff as well,
but I think it's both.
Pete
"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
-----Original Message-----
Sent: Wednesday, May 21, 2003 12:12 PM
To: Multiple recipients of list ORACLE-L
But in your quote from the Secure Configuration Guide for Oracle9iR2, it says "SCOTT" is not locked. Isn't SCOTT the sample schema? So if it isn't locked, why would they tell you to unlock it? I would probably go with "C" as well, but I think the question and answers are poorly written.
Just my $.02
-Scott
At 08:36 AM 5/21/03 -0800, you wrote:
>Was just reading this. From the "Secure Configuration Guide for
>Oracle9iR2":
>
>"The DBCA automatically locks and expires all default database user
>accounts except SYS, SYSTEM, SCOTT and DBSNMP upon the successful creation
>of a database server instance."
>
>So that question is unclear. I would answer C.
>
>The answer in D is very dangerous.
>
>I highly suggest reading through this document. Lots of important
>information.
>
>It is so good to be back into this stuff again...!!!!!
>
>Lisa Koivu
>Oracle Database MONKEY
>Fairfield Resorts, Inc.
>5259 Coconut Creek Parkway
>Ft. Lauderdale, FL, USA 33063
>Office: 954-935-4117
>Fax: 954-935-3639
>Cell: 954-683-4459
>
>
>-----Original Message-----
>Sent: Wednesday, May 21, 2003 11:02 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi list , I came across a question while preparing for my exam
>
>
>
>QUESTION :
>
>You created a database by using the Database Configuration Assistant.
>What must you do to access a user account in the sample schemas?
>
>A. Create the user account and unlock the account.
>
>B. Create the user account and define a password.
>
>C. Unlock the user account and define a password.
>
>D. Set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from). You may also send the HELP
>command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Koivu, Lisa
> INET: Lisa.Koivu_at_Fairfieldresorts.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from). You may also send the HELP
>command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: sstefick_at_harpercollege.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: peter.sharman_at_oracle.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed May 21 2003 - 16:02:04 CDT