what is the exact difference between sysdba and sysoper in oracle?
i got the below answer , but i want to know why these two roles seperatly maintained in oracle.
why we can't use sysdba only.
what exact scenario the sysoper will be worked out. compare to sysoper any sysdba , the sysdba having more privileges.
then why we need sysoper?
-->
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.
No comments:
Post a Comment