Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Step 3. Grant Permissions to Combined and Archive Users

Step 3. Grant Permissions to Combined and Archive Users

Modify the sample script to grant the combined and archive users access to a seamless view of production and archive data.

Sample Script

The following script is a sample script that you can use to grant seamless access privileges to the combined user and archive users. Replace
USERNAME
with the correct combined or archive user name and run the script.
GRANT ALTER SESSION TO &&USERNAME; GRANT CREATE DATABASE LINK TO &&USERNAME; GRANT CREATE PROCEDURE TO &&USERNAME; GRANT CREATE SEQUENCE TO &&USERNAME; GRANT CREATE SESSION TO &&USERNAME; GRANT CREATE SYNONYM TO &&USERNAME; GRANT CREATE TABLE TO &&USERNAME; GRANT CREATE TRIGGER TO &&USERNAME; GRANT CREATE VIEW TO &&USERNAME; GRANT EXECUTE ANY PROCEDURE TO &&USERNAME; GRANT SELECT ANY DICTIONARY TO &&USERNAME; GRANT SELECT ANY SEQUENCE TO &&USERNAME; GRANT SELECT ANY TABLE TO &&USERNAME; GRANT SELECT_CATALOG_ROLE TO &&USERNAME;

0 COMMENTS

We’d like to hear from you!