Re: Oracle 8.1.5 -- set up admin account

I can tell you are a newbee here. NO don't just go deleting tables. You can really muck things up. Scott has tables for practice that you can do as you please, but the sys and system tables I would leave alone if I were you.

Internal is GOD so to speak. He can start and stop the database as well as a buch of other tasks. You need this we the shit hits the fan.

Sys is just about a powerful as Internal when logged in as DBA.

System is the next step removed, but still important.

You will ALWAYS have INTERNAL, SYS and SYSTEM.

Unless you are do administration to the database, I would create you own account or use Scott to dink around in. You can give a normal user DBA power and privledges.

Create yourself a new user and that user will have no tables in it except the ones you create and a selective few from the list bellow (some are views) that you cannot or should not remove.

On Mon, 01 Jan 2001 06:44:13 GMT, m_010_at_yahoo.com (tim leung) wrote:

>Hi,
>I justed install oracle 8.1.5 enterprise on my win2000 machine. But It
>didn't ask me to set any administrator password. Any one knows how can
>I set an admin account that has all privilege.
>
>My friend told me to use scott / tiger to login to SQL*Plus. Is this
>the default account whenever I create a new DB? Does scott / tiger
>has all the admin privilege? When I login, is the host string is same
>as SID?
>
>I had create another DB and it show 3 accounts. What's the difference?
>
>INTERNAL : oracle
>SYS : change_on_install
>SYSTEM : manager
>
>When I take a look what's inside the database. It has many tables that
>I don't need. Any way I can create a DB without any tables in it,
>just like mySQL? Can I delete those tables? When I type:
>
>SQL> select table_name from all_tables;
>TABLE_NAME
>------------------------------
>DUAL
>SYSTEM_PRIVILEGE_MAP
>TABLE_PRIVILEGE_MAP
>STMT_AUDIT_OPTION_MAP
>AUDIT_ACTIONS
>PSTUBTBL
>DEF$_TEMP$LOB
>DEPT
>EMP
>BONUS
>SALGRADE
>LOCATION
>DEPARTMENT
>JOB
>EMPLOYEE
>SALARY_GRADE
>PRODUCT
>PRICE
>CUSTOMER
>SALES_ORDER
>ITEM
>
>TABLE_NAME
>------------------------------
>OGIS_SPATIAL_REFERENCE_SYSTEMS
>AURORA$IIOP$SYSTEM$PROPERTIES
>MD$DICTVER
>HELP
>
>25 rows selected.
>
>Thanks.
  Received on Tue Jan 09 2001 - 00:42:41 CST