Hi Guys ,
I need some info here ,
What exactly is difference between sysdba and
sysoper roles and how can I set up osdba osoper roles on unix ( i mean what os
permissions does it need ).
-ak
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
Title: 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