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
Wednesday, June 25, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment