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