Wednesday, 5 September 2012

In a federated system, a userid is used for the CREATE SERVER definition at the DB2 data source. Which of the following privileges should it have?

A. SELECT on the catalog at the DB2 data source
B. UPDATE on the CREATE SERVER definition table
C. SELECT on the tables for which nicknames are created
D. INSERT on the tables for which nicknames are created

Ans : A

No comments: