1

What rights should I give to DB user to execute REFRESH TABLE SOME_MQT; statement? Is it enough GRANT ALL ON SOME_MQT TO USER %USER_NAME ? DB2 version: 9.5.3

adrift
  • 637
  • 2
  • 10
  • 34

1 Answers1

0

The documentation for the REFRESH TABLE Statement seems pretty clear on that.

The privileges held by the authorization ID of the statement must include at least one of the following:

  • CONTROL privilege on the table
  • SYSADM or DBADM authority

I'm not sure whether GRANT ALL is enough. It's not unusual for a dbms to grant a subset of all possible privileges using GRANT ALL. But it's easy enough to test. Just GRANT ALL on a materialized view (not necessarily the view in question; use a scratch view) and let the user try to refresh it.

Mike Sherrill 'Cat Recall'
  • 91,602
  • 17
  • 122
  • 185