|
Problem IC89459
|
Status: Closed |
ADMIN MOVE TABLE ON TABLE WITH VIEWS - GRANTS NOT PRESERVED ON VIEWS WHEN AUTO_REVAL IS DISABLED OR NO_AUTO_REVAL IS SPECIFIED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When issuing ADMIN_MOVE_TABLE for the table with views and the
dbm cfg AUTO_REVAL is disabled or NO_AUTO_REVAL is specified in
ADMIN_MOVE_TABLE option, we'll see the error message below:
db2 "create table test.tab2(id1 integer, id2 integer)"
db2 "insert into test.tab2 values (1,2),(2,3),(3,4),(4,5),(5,6)"
db2 "create view test.v2 as select * from test.tab2"
db2 "grant select on test.v2 to newton"
doas newton "db2 connect to otmdb"
doas newton "db2 'select * from test.v2'"
db2 "call
admin_move_table('TEST','TAB2','','','','','','','','NO_AUTO_REV
AL','MOVE')"
doas newton "db2 'select * from test.v2'"
SQL0551N "NEWTON" does not have the required authorization or
privilege to
perform operation "SELECT" on object "TEST.V2". SQLSTATE=42501 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* users who use admin_move_table procedure *
****************************************************************
* PROBLEM DESCRIPTION: *
* When issuing ADMIN_MOVE_TABLE for the table with views and *
* the *
* dbm cfg AUTO_REVAL is disabled or NO_AUTO_REVAL is specified *
* in *
* ADMIN_MOVE_TABLE option, we'll see the error message below: *
* *
* db2 "create table test.tab2(id1 integer, id2 integer)" *
* db2 "insert into test.tab2 values *
* (1,2),(2,3),(3,4),(4,5),(5,6)" *
* db2 "create view test.v2 as select * from test.tab2" *
* db2 "grant select on test.v2 to newton" *
* doas newton "db2 connect to otmdb" *
* doas newton "db2 'select * from test.v2'" *
* db2 "call *
* admin_move_table('TEST','TAB2','','','','','','','','NO_AUTO *
* _REV *
* AL','MOVE')" *
* *
* doas newton "db2 'select * from test.v2'" *
* SQL0551N "NEWTON" does not have the required authorization *
* or *
* privilege to *
* perform operation "SELECT" on object "TEST.V2". *
* SQLSTATE=42501 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97fp8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
v97fp8 will contain the changes, and the grants in the views
will be added during the ADMIN_MOVE_TABLE. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91753
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.01.2013
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
