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.
Effectively, this system privilege allows a user to connect as user SYS.
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