这篇文章通过例子讨论sql92_security初始化参数的作用。
sql92_security
Oracle 11.1.0:
Parameter Name: | sql92_security | ||
Description: | require select privilege for searched update/delete | ||
Type: | BOOL | Obsoleted: | FALSE |
Can ALTER SESSION: | FALSE | Can ALTER SYSTEM: | FALSE |
参考文章:http://www.orafaq.com/parms/parm1917.htm
当sql92_security被设置成TRUE时,对表执行UPDATE/DELETE操作时会检查当前用户是否具备相应表的SELECT权限。下面的例子展示了该参数的作用:
C:\Users\LIUBINGLIN>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期二 5月 21 18:17:45 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter sql92
NAME TYPE
------------------------------------ ----------------------