|
Problem IC91753
|
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 / A10 - 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 stored 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 DB2 V101FP3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
v101fp3 will contain the changes, and the grants in the views
will be added during the ADMIN_MOVE_TABLE. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.04.2013
21.10.2013
21.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
