Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    6

    Unanswered: What authority needed IN IBM z/os DB2 V8

    I created MQT table in IBM Z/0S DB2 V8. I was able to refresh that. But I want to know what type of access needed for user to do the same ( who has only select, insert,upadte,delete on this table. Do they need DB ADM on that database?

    Thank you

    Ravi

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by sankarravi6@gmail View Post
    I created MQT table in IBM Z/0S DB2 V8. I was able to refresh that. But I want to know what type of access needed for user to do the same ( who has only select, insert,upadte,delete on this table. Do they need DB ADM on that database?

    Thank you

    Ravi
    Try the SQL Reference Manual. It will list the authority needed for the REFRESH statement.

    Not sure why you allow users to insert, update, or delete row in an MQT table. Maybe there is a good reason, but sounds a little dangerous to me.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •