Oracle Database - SYSDBA privilege

Card Puncher Data Processing

About

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 at user data.

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

SYSDBA is used internally and has specialized functions. Its behavior is not the same as for general users.

SYSDBA privileges

  • Perform STARTUP and SHUTDOWN operations
  • ALTER DATABASE: open, mount, back up, or change character set
  • CREATE DATABASE
  • DROP DATABASE
  • CREATE SPFILE
  • ALTER DATABASE ARCHIVELOG
  • ALTER DATABASE RECOVER. (SYSOPER is limited to complete recovery only)
  • Includes the RESTRICTED SESSION privilege

Effectively, this system privilege allows a user to connect as user SYS.

Connect as Sysdba references the SYS schema

When you connect using

connect sys/passwd as sysdba

your connecting as the SYS user and requesting SYSDBA privs.

Example :

CONNECT oe/oe
CREATE TABLE admin_test(name VARCHAR2(20));


Later, user oe issues these statements:

CONNECT oe/oe AS SYSDBA
SELECT * FROM admin_test;


User oe now receives the following error:

ORA-00942: table or view does not exist 

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - How to change the password for the account SYS/SYSTEM ?

You must connect with the SYSDBA privilege. If you don't remember the sys password, you can perform a OS authentication. Check this article for more information : If you don't give the SYS password...
Card Puncher Data Processing
Oracle Database - How to connect SYS as SYSDBA without password

When you connect as sysdba issuing a 'CONNECT / AS SYSDBA', Oracle checks if your account is a member of the os group 'ORA_sid_DBA' or 'ORA_DBA' group. Operating System Group UNIX User Group Windows...
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 - Oracle Enterprise Manager Database Control (Database Control)

Oracle Enterprise Manager Database Control is one of the two way that Oracle Enterprise Manager can be installed. You can deploy Oracle Enterprise Manager: locally on the database system called database...
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 - SYSOPER privilege

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...



Share this page:
Follow us:
Task Runner