Post-installation steps

Semarchy xDM is now up and running. This document describes the post-installation and next recommended tasks for the Administrators and Project Managers.

Finalize repository read-only user privileges

The repository read-only user connects to the repository to render the xDM Discovery profiles and needs SELECT privileges on the profiling tables created with the repository. Run the following scripts to grant to the repository read-only user select privileges on the profiling tables created in the repository schema.

Example 1. Grant SELECT on profiling tables to the read-only user (PostgreSQL)
/* Grant select privileges on the profiling tables */
GRANT USAGE ON SCHEMA <repository_user> TO <repository_readonly_user>;
GRANT SELECT ON TABLE
    <repository_user>.PRF_PROFILING,
    <repository_user>.PRF_TABLE,
    <repository_user>.PRF_COLUMN,
    <repository_user>.PRF_DIST_VALS,
    <repository_user>.PRF_DIST_PATTERNS
TO <repository_readonly_user>;
Example 2. Grant SELECT on profiling tables to the read-only user (SQL Server)
USE <repository_database_name>
GO
/* Grant select privileges on the profiling tables */
GRANT SELECT ON PRF_PROFILING TO <repository_readonly_user>;
GRANT SELECT ON PRF_TABLE TO <repository_readonly_user>;
GRANT SELECT ON PRF_COLUMN TO <repository_readonly_user>;
GRANT SELECT ON PRF_DIST_VALS TO <repository_readonly_user>;
GRANT SELECT ON PRF_DIST_PATTERNS TO <repository_readonly_user>;
Example 3. Grant SELECT on profiling tables to the read-only user (Oracle)
-- Grant select privileges on the profiling tables
GRANT SELECT ON <repository_user>.PRF_PROFILING TO <repository_readonly_user>;
GRANT SELECT ON <repository_user>.PRF_TABLE TO <repository_readonly_user>;
GRANT SELECT ON <repository_user>.PRF_COLUMN TO <repository_readonly_user>;
GRANT SELECT ON <repository_user>.PRF_DIST_VALS TO <repository_readonly_user>;
GRANT SELECT ON <repository_user>.PRF_DIST_PATTERNS TO <repository_readonly_user>;

Next steps for administrators

Administrators should proceed with the following tasks:

See Get started with administration for more information about administrative tasks.

Next steps for project managers

Project Managers should proceed to the following tasks: