|
Problem IC91753
|
Status: Geschlossen |
ADMIN MOVE TABLE ON TABLE WITH VIEWS - GRANTS NOT PRESERVED ON VIEWS WHEN AUTO_REVAL IS DISABLED OR NO_AUTO_REVAL IS SPECIFIED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
v101fp3 will contain the changes, and the grants in the views
will be added during the ADMIN_MOVE_TABLE. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.04.2013
21.10.2013
21.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
