Re: Oracle Users

Hi Nadejda
The standard users are
SYS
SYSTEM
SCOTT
DBSNMP
SYS is the owner of the datadictionary, never create tables under SYS. SYSTEM is the owner of the various product repositories, like Designer, Oracle Names etc,
SCOTT is a demo account
Internal is not a real user, you will not find it in dba_users. It is a mechanism to make sure you can connect to the database (as SYS), when the database is not running. Mainly used for maintenance purposes. SYSOPER is not a user, but a privilege/role. It gives you more authority than normal DBA privileges, yet to be able to restrict access to the database to non-dba users, you need to have the SYSDBA role. Other users can and should be created to develop your own tables, you should leave the above mentioned users alone.

Hth

Sybrand Bakker, Oracle DBA

Nadejda Maslennikova <cy913_at_FreeNet.Carleton.CA> wrote in message news:7lae97$pnm_at_freenet-news.carleton.ca...
>
> Hello,
>
> Please, tell me what users there are in Oracle? Upon installation we have
> SYS, SYSTEM. I didn't understand, if internal user is created by the
> system itself or by administrator? Reading the documentation I saw
> other users like SYSOPER, what does it do?
> User SCOTT is a sample one...
>
> Well, I would like to know what users are created by the Oracle
> system and what they are for. Thank you.
>
> Nadia
>
>
>
> --
> email: cy913_at_freenet.carleton.ca
Received on Tue Jun 29 1999 - 13:09:17 CDT