oracle漏洞怎么处理,【PSU】记Oracle一次高危漏洞补丁修复过程

[oracle@ora11 soft]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 14 08:57:43

2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release

11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real

Application Testing options

SQL> create user test identified by test;

User created.

SQL> grant create session,connect to test;

Grant succeeded.

SQL> grant select on scott.emp to test;

Grant succeeded.

SQL> conn test/test

Connected.

SQL> select * from scott.emp;EMPNO ENAME      JOB           MGR HIREDATE                   SAL  COMM

DEPTNO

------ ---------- --------- -------

------------------- ---------- ----- -------

7369

SMITH      CLERK        7902 1980-12-17 00:00:00        800            20

7499

ALLEN      SALESMAN     7698 1981-02-20 00:00:00       1600

300      30

7521 WARD       SALESMAN     7698 1981-02-22 00:00:00       1250

500      30

7566

JONES      MANAGER      7839 1981-04-02 00:00:00       2975            20

7654

MARTIN     SALESMAN     7698 1981-09-28 00:00:00       1250

1400      30

7698

BLAKE      MANAGER      7839 1981-05-01 00:00:00       2850            30

7782

CLARK      MANAGER      7839 1981-06-09 00:00:00       2450            10

7788

SCOTT      ANALYST      7566 1987-04-19 00:00:00       3000            20

7839

KING       PRESIDENT         1981-11-17 00:00:00       5000            10

7844

TURNER     SALESMAN     7698 1981-09-08 00:00:00       1500     0

30

7876

ADAMS      CLERK        7788 1987-05-23 00:00:00       1100            20

7900

JAMES      CLERK        7698 1981-12-03 00:00:00        950            30

7902

FORD       ANALYST      7566 1981-12-03 00:00:00       3000            20

7934

MILLER     CLERK        7782 1982-01-23 00:00:00       1300            10

SQL> update scott.emp set sal=1699 where ename='ALLEN';

update scott.emp set sal=1699 where ename='ALLEN'

*

ERROR at line 1:

ORA-01031: insufficient privileges

SQL> update (with temp as (select * from

scott.emp) select * from temp) set sal=1699 where ename='ALLEN';

1 row updated.

SQL> commit;

Commit complete.