Re: Oracle 8.1.5 -- set up admin account

The sys account has all the privileges and owns objects. The system account is also privileged. The default passwords are those you listed below. They can be changed by logging in as sys or system and issuing:

alter user sys identified by <whateveryouwant>;

where "<whateveryouwant>" is your new password. Changing these passwords protects your database since the default passwords are well known. But since your database is likely only for personal training, security is not as important.

The scott schema with password tiger is for demo purposes. You can use this account to learn something about the system. It already contains objects to experiment with. You can also drop it when it is no longer needed.

You may also create a new account for experimentation that has no objects by issuing:

create user <newusername> identified by <whateveryouwant>;

where "<newusername>" is the schema name and "<whateveryouywant>" is the password for that schema. Then grant privileges to this account so you can access it and do things with it:

grant connect, resource to <newusername>;

After that you may connect to this schema, create tables, views, and so forth.

This might get you started.

Note that 8.1.5 is out-of-date. If you are going to learn a release you might as well get the 8.1.7 release. Although you may download it from http://technet.oracle.com directly, I found it easier to let CD Post (http://www.cdpost.com) do the downloading, create a cd and mail it to me (it is a bit under 600 megabytes). (I set my bookmark for technet as http://mylogin:mypassword@technet.oracle.com) where "mylogin" is my technet login and "mypassword" is my password to technet. You would obviously use your own. This gets me logged in immediately.)

The documentation can also be downloaded from technet. You might start with the installation manual, the concepts manual, the administration manual and the sql reference manual. Actually, the amount of documentation is overwhelming. However, the quality of the documentation is high and it is worth mastering the major manuals.

Frank Hubeny

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 02 2001 - 04:35:56 CST