SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 73

Two very special and important system privileges are SYSDBA
and SYSOPER. That's why I want to discuss them separately.
Following table describes the power lies beneath these two
system privileges.

Create new database
Startup, Shut down database
Alter database with the OPEN, MOUNT,
BACKUP, CHANGE CHARACTER SET,
ARCHIVELOG and RECOVER options
Create SP file

SYSDBA

Startup, Shut down database
Alter database with the OPEN, MOUNT,
BACKUP, ARCHIVELOG and
RECOVER options
Create SP file
Figure 2-23: Two very important system privileges with corresponding
privileges.

SYSOPER

Example:

CREATE ROLE hr_emps;

GRANT SELECT, UPDATE
ON emp_test
TO hr_emps;
GRANT hr_emps
TO margorie, daisy, jessie, semper;
In this example we have first created the role hr_emps and next
we assign certain privileges to it and finally we have assigned it
to all the employees of hr (Human Resources department). After
a month, new business rule comes up which says that all the hr
employees should only be having SELECT privilege on
emp_test table. To implement this rule all you have to do is to
revoke the privilege from the role e.g.