on 2020 Apr 07 12:09 PM
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 .
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
47 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.