Oracle 8.1.5 -- set up admin account
Date: Mon, 01 Jan 2001 06:44:42 GMT
Message-ID: <3a522750.10170864_at_enews.newsguy.com>
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 Mon Jan 01 2001 - 07:44:42 CET