Create Repository Role - MANAGEMENT_CONSOLE_PROC

[martin_chambers]

We have SAP HANA SPS9.

I have started creating repository roles using the web ide. I understand that it is possible to create repository roles without first having to have the privileges one wishes to assign.

This worked just fine while I created a role for the DBA Cockpit. But when I tried to add the object privilege for the procedure MANAGEMENT_CONSOLE_PROC with EXECUTE, I got an error message, "insufficient privilege: Not authorized at ptime/query/..."

I ran an authorization check but the result was inconclusive.

Any suggestions that help me solve this problem will be much appreciated.

Cheers,

Martin

[lbreddemann · Accepted solution]

This procedure is an internal API to be used in the SAP HANA administration tools.

Direct usage is not supported or foreseen.

As this procedure is a system object, you cannot put it in a repository role. Only direct granting of the privilege and granting to a catalog role is possible.

[martin_chambers · Accepted solution]

Hi Lars,

I noticed that there is a role DBA_COCKPIT. Is it possible to add this role to a repository role?

Martin