Hi I want to grant SELECT privileges on objects in the _SYS_REPO
Error message while applying the privilege assignment:
Could not modify user <user_name>'. Could not grant privilege 'SELECT' on 'ACTIVE_OBJECT (_SYS_REPO)'. Can only grant privileges for objects in content schemas"
Please help me solve it.
SAP HANA studio uses a stored procedure call to grant permissions for objects in _SYS*-schemas.
Instead of using the authorization management tab, grant the SQL privileges via SQL commands.
Examples (replace <user_name> by the name of the user or role that should receive the privilege):
grant SELECT on _SYS_BI.BIMC_CUBES to <user_name>;
grant SELECT on _SYS_BI.BIMC_DIMENSIONS to <user_name>;
grant SELECT on _SYS_BI.BIMC_PROPERTIES to <user_name>;
grant SELECT on _SYS_BI.BIMC_VARIABLE to <user_name>;
grant EXECUTE on SYS.REPOSITORY_REST to <user_name>;
grant EXECUTE on _SYS_REPO.GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT to <user_name>;
grant EXECUTE on _SYS_REPO.GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE to <user_name>;
grant SELECT on _SYS_REPO.OBJECT_HISTORY to <user_name>;
grant SELECT on _SYS_REPO.ACTIVE_OBJECT to <user_name>;
grant SELECT on _SYS_REPO.ACTIVE_OBJECTCROSSREF to <user_name>;