cancel
Showing results for 
Search instead for 
Did you mean: 

Analytical Privilege and Role File Issue in Web IDE XSA for HANA

former_member210043
Participant
0 Kudos
1,251

Hi Team,

I am getting the below error while building the APRole.hdbrole.

The file requires "db://AP_POC_WEBIDE::AP_POC_WEBIDE" which is not provided by any file [8212001] at "src/APRole.hdbrole" (0:0)

1. I was able to successfully create the AP_POC_WEBIDE.hdbanalyticprivilege

2. created the APRole.hdbrole and tried to build it but got the error as " The file requires "db://AP_POC_WEBIDE::AP_POC_WEBIDE" which is not provided by any file [8212001] at "src/APRole.hdbrole" (0:0) "

APRole.hdbrole file Code :

{

"role": { "name":"start123.startHDB::Analytical_Privilege_Role",

"schema_privileges":[{ "privileges": [ "SELECT"] }],

"schema_analytic_privileges": [

{ "privileges":[ "AP_POC_WEBIDE" ]

}]

}

}

Please help in this regard and also help with whole process to complete successfully assign the Analytical Privilege to a specific User.screen.png

-Using the Web IDE XSA for HANA on Primise.

Followed below link to create the analytical privilege and role file .

https://blogs.sap.com/2019/02/17/analytical-privileges-on-cv-for-restricted-data-access-in-reporting...

View Entire Topic
jan_zwickel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Nikil,

you seem to open a normal SQL console. If you right-click on your database you have the option "Open SQL Console (Admin)" This should return you a current_user that ends in "_DT" and not "_RT"

Best,

Jan

former_member210043
Participant
0 Kudos

Hi Jan,

I tried as per your comments opened the sql admin of the HDI Container of the project did the below steps.

SELECT current_user from dummy - Successfully executed

set schema POC3_SCHEMA_2_993BCOYK1573J80U1YQRJIP93_DT; -- Successfully executed

CREATE LOCAL TEMPORARY COLUMN TABLE #ROLES LIKE _SYS_DI.T_NO_SCHEMA_ROLES; - Getting the error as unresolved Table T_NO_SCHEMA_ROLES


Attached screen shot for reference.screen6.png



Thanks ,

Nikil