Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

Security Views

Security Views

Security views allow you to see user information. The REP_USERS view provides a list of all PowerCenter users.
The following table lists user information in the REP_USERS view:
Column Name
Datatype
Description
USER_ID*
NUMBER
User ID (primary key).
NAME_SPACE
VARCHAR2 (240)
Security domain the user belongs to.
USER_NAME
VARCHAR2 (240)
User name.
STATUS
NUMBER
Not applicable. Reserved for future use.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!