Table of Contents

Oracle Database - SYSDBA privilege

About

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

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

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