DB2 FOR LUW / DB2FORLUW / 970 - DB2

The user receives the SQL0551N error when using a privilege 
granted to the user through a role, and the role shares the same 
name with the group to which the user belongs. 
 
For example, if user U belongs to group G, where G=R 
 
create role R 
grant role R to user U 
grant select on table T to role R 
terminate 
(connect to database as user U) 
select * from T 
 
SQL0551N  "U" does not have the privilege to perform 
operation 
"SELECT" 
on object "T".  SQLSTATE=42501 
 
An entry can be seen in SYSCAT.ROLEAUTH to confirm that the user 
was granted the role.

USERS AFFECTED: ALL 
 
PROBLEM DESCRIPTION: 
 
The user receives the SQL0551N error when using a privilege 
 
granted to the user through a role, and the role shares the same 
name with the group to which the user belongs. 
 
 
PROBLEM SUMMARY: 
 
The user receives the SQL0551N error when using a privilege 
 
granted to the user through a role, and the role shares the same 
name with the group to which the user belongs.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 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 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 1

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.07.2009
23.12.2009
23.12.2009

9.7.FP1