Database Reference
In-Depth Information
Figure 10-1.
Overwriting the autoexec file from ADVISOR
The autoexec config file shown in the screenshot in the root of C:/ is executed automatically by the OS at startup
and is the target of many a virus writer, so should not be writable by DB users with monitoring privileges, especially
when that access directly contradicts the stated functionality within the documentation. So WRITE privilege on DB
directory is not needed by ADVISOR to WRITE to the OS. Additionally, holders of ADVISOR do not require EXECUTE
privilege on a DB directory to execute files on the OS. Why? Because they are already there, conveniently placed in the
form of
qopiprep.bat
. For example:
Create our test user first:
C:\Windows\System32>sqlplus sys/lowsec@orcl4 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Aug 8 11:54:03 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
