Oracle Database - SYSOPER privilege

Card Puncher Data Processing

About

A user can connect with different levels of privileges, namely:

  • SYSDBA (the root of administrator of the database)
  • and SYSOPER.

SYSOPER allows a user to perform basic operational tasks, but without the ability to look at user data.

By default, all members with the SYSDBA privilege have all privileges granted by the SYSOPER privilege.

SYSOPER Privileges

  • Perform STARTUP and SHUTDOWN operations
  • CREATE SPFILE
  • ALTER DATABASE OPEN/MOUNT/BACKUP
  • ALTER DATABASE ARCHIVELOG
  • ALTER DATABASE RECOVER (Complete recovery only. Any form of incomplete recovery, such as UNTIL TIME|CHANGE|CANCEL|CONTROLFILE requires connecting as SYSDBA.)
  • Includes the RESTRICTED SESSION privilege

Documentation / Reference





Discover More
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Oracle Database 11gr2 Os Group
Oracle Database - Operating System Group

Operating System User and Group permit to allocate privileges. The documentation talks logical OS group (OSDBA, OSOPER, OSASM). Their implementation (their creation on the OS level) may be differ in...
Card Puncher Data Processing
Oracle Database - Privileges

A user can connect with different levels of privileges: namely for the database: SYSDBA (the root or administrator of the database) and SYSOPER. SYSOPER allows a user to perform basic operational...
Card Puncher Data Processing
Oracle Database - SYSDBA privilege

A user can connect with different levels of privileges, namely: SYSDBA (root or administrator) and SYSOPER. SYSOPER allows a user to perform basic operational tasks, but without the ability to look...



Share this page:
Follow us:
Task Runner