Wednesday, June 25, 2008

db2 8.1 describe table

on db2 8.1, the user cannot do 'describe table tablename', it gives error message 'user doesn't have select privileage on syscat.columns '.

solution 1:
use db2inst1, then 'describe table schema.table'' e.g. describe table jephe.user_account.


solution 2:

grant select on table syscat.columns to user 'username' e.g. grant select on table syscat.columns to user jephe

No comments: