post-installation-grant-access.sql

/*******************************************************************************
** Oracle database post-installation scripts
** Semarchy xDM Tutorials
** Copy and paste the SQL DDL scripts and use them in the tutorial.
** Copyright (c) 2021 Semarchy
*******************************************************************************/

/************************************************
Grant the read-only user access to the repository
************************************************/
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_PROFILING TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_TABLE TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_COLUMN TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_DIST_VALS TO SEMARCHY_REPOSITORY_RO;
GRANT SELECT ON SEMARCHY_REPOSITORY.PRF_DIST_PATTERNS TO SEMARCHY_REPOSITORY_RO;