RE: sysdba and sysoper

SYSDBA can do more than start/stop the database. It has a lot more functionality that sysoper (Operator mode) which is normally used for basic database functions such as start/stop.

SYSOPER privilege allows operations such as:
        Instance startup, mount & database open ;
        Instance shutdown, dismount & database close ;
        Alter database BACKUP, ARCHIVE LOG, and RECOVER.
        This privilege allows the user to perform basic operational tasks
        without the ability to look at user data.

SYSDBA privilege includes all SYSOPER privileges plus full system privileges
        (with the ADMIN option), plus 'CREATE DATABASE' etc..
        This is effectively the same set of privileges available when
        previously connected INTERNAL.

-----Original Message-----
From: Sajid Iqbal [mailto:siqbal_at_vianetworks.co.uk] Sent: 07 December 2001 10:10
To: Multiple recipients of list ORACLE-L Subject: sysdba and sysoper

Hi

Can anyone tell me the difference between sysdba and sysoper.. in the book it says :-

sysdba - A priviliged role granted to database users allowed to start and stop the Oracle Database

sysoper - A priviliged role granted to database users allowed to start and stop the Oracle Database

The same explanation ?

Also whats a tempfile in oracle ?

Regards

-- 
Sajid Iqbal






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sajid Iqbal
  INET: siqbal_at_vianetworks.co.uk


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================