Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Configure Permissions

Configure Permissions

To extract metadata from a PowerCenter repository, the login user that you specify in the resource connection properties must be the PowerCenter repository database user.
The PowerCenter repository database user account requires the following permissions on the PowerCenter repository database:
  • Select table
  • Select view
  • Create view
    After you upgrade Metadata Manager, you need the create view permission on the PowerCenter repository database only during the first load.
  • Drop view
In addition, if the PowerCenter repository is on IBM DB2 for LUW, the user account also requires create and drop function permissions.

0 COMMENTS

We’d like to hear from you!