Re: Oracle 8.1.5 -- set up admin account

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.

system/manager
sys/change_on_install

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"