Online Tutorials & Training Materials | STechies.com
Register Login

_SYS_REPO not granting SELECT privilege

Shalesh Singh Visen || 26 May 2016 3:37 pm || 2

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.


Comments

  • 26 May 2016 3:39 pm Best Answer

    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>;

  • 11 Feb 2017 1:59 am

    Hi Rohit,

    I have the same issue but your solution didn't work , system throws not authorised error. I am able to grant privileges on the other schemas. Can you help?

     

    Thanks,

    Prasad