SYSOPER
|
SYSDBA
|
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 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.
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. |
Note:
1.SYSDBA
and SYSOPER are system privileges and don't misunderstand with DBA.
2.DBA
is a role which includes all system privileges excluding sysdba and sysoper.
3.sysdba and sysoper can be granted to user for administrative tasks by sys user.
3.sysdba and sysoper can be granted to user for administrative tasks by sys user.
Do you like this post? Please share this article.
HTML Link Code:
Post a Comment