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.
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 the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.
