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
Showing posts with label syscat.columns. Show all posts
Showing posts with label syscat.columns. Show all posts
Wednesday, June 25, 2008
Subscribe to:
Posts (Atom)