Working as the SYS User

SYS has a schema (by the same name) and has lots of structures belonging to his account. You can connect (log in) to a database as SYS, but a unique requirement of that user is that you have to specify that you are using the SYSDBA privilege. (Note that in the text I will be using all uppercase for reserved words in Oracle commands and for default Oracle users, schemas, and structures.)

CONNECT sys AS sysdba;

At that point, you will have to enter the password associated with the SYS user.

images Note You can find a script of the following commands in the file named Chapter2/Sys.sql.

System Privileges

SYSDBA is a unique system ...

Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.