Showing posts with label syscat.columns. Show all posts
Showing posts with label syscat.columns. Show all posts

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