create procedure db2inpe.aa13
(
in ii_mon integer,
out oi_statuscode integer
)
begin
create table ii
(
id int
) ;
commit ;
update ii set id=null ;
end;
completed successfully.
Statement processed successfully in 0.06 secs.
db2inpe@dmsrvr:~> db2level
DB21085I Instance "db2inpe" uses "32" bits and DB2 code release "SQL09075"
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23291", and Fix Pack
"5".
Product is installed at "/opt/ibm/db2/V9.7".
====================================================================================
== v9.5 fp0
===================================================================================
create procedure db2inst2.aa13
(
in ii_mon integer,
out oi_statuscode integer
)
begin
create table ii
(
id int
) ;
commit ;
update ii set id=null ;
end;
[IBM][CLI Driver][DB2/LINUX] SQL0551N "DB2USER" 不具有对对象 "DB2USER.II" 执行操作 "UPDATE" 的必需权限或特权。 LINE NUMBER=15. SQLSTATE=42501
Statement processed with ERROR.
db2inst2@dmsrvr:/home/db2inpe/sqllib/db2dump> db2level
DB21085I Instance "db2inst2" uses "32" bits and DB2 code release "SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", and Fix Pack
"0".
Product is installed at "/opt/ibm/db2/v9.5".
两个存储过程都是使用普通用户,没有dbadm 权限,为啥一个可以创建成功,一个不可以,9.7 有啥 新特性吗
收起