Re: What are SYSDBA, SYSOPER, SYS, and SYSTEM?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 24 Nov 2004 01:38:20 GMT
Message-ID: <Xns95AAB36F1C44ESunnySD@68.6.19.6>

aleatory_at_hotmail.com (aleatory) wrote in news:a68a4ee0.0411231618.2a0e957e_at_posting.google.com:

> Hello all,
>
> An Oracle newbie would like to ask a few questions
> on SYSDBA, SYSOPER, SYS, and SYSTEM.
>
> Am I correct to say:
>
> *SYSDBA
> Much like UNIX's root account. The account basically
> can do anything including destroying the database.
>
> *SYSOPER
> Simply a bit less privilaged account than SYSDBA.
>
> *SYSTEM
> I understand Oracle automatically provides this
> account, but don't know differences between SYSDBA
> and SYSTEM.
>
> *SYS
> Really not sure about this. I know Oracle tells me
> SYSDBA is SYS after executing the following:
>
> | SQL> connect /as sysdba
> | SQL> show user
> | User is "SYS"
>
> Some insightful and analogous comments are highly
> appreciated.
>
> Many thanks in advance,
>
> alea
>

Please, RTFM yourself.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm

and there are more where that came from

http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage Received on Tue Nov 23 2004 - 19:38:20 CST