on 12-02-2014 5:32 AM
Hello!
We are trying to demonstrate a big data use case to one of our customer using HANA and SAPUI5. Though we are certain that HANA is more efficient than our current implementation using NoSQL database, we are not able to demonstrate that effectively because of restrictions on access privileges
I created analytic view and attribute view on _SYS_BIC schema. View uses table from _SYS_BIC scheme schema. I am getting errors while selecting data preview
However, if I try to get to the element from select query and
I receive: Could not execute 'SELECT * FROM "_SYS_BIC"."p1941009112trial.emchana.emc.views/AT_EROLLMENT_STATUS"' SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized.SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized
I executed successfully
call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"
But this doesn't help.
Does anyone know what privileges should be assigned to user and how can this be done?
Thanks,
Aniket
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to have SELECT & EXECUTE privilege on _SYS_BIC schema.
Also need to have CATALOG READ system privilege and CONTENT_ADMIN role granted.
CONTENT_ADMIN : This role has most vital privileges. It has :
a. SQL Privileges on Schema _SYS_BIC with GRANT OPTION
b. SQL Privileges on Schema _SYS_BI with GRANT OPTION
Regards,
Prasana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aniket,
I guess you have SELECT access on _SYS_BIC schema.
Are you using Analytic Privileges for your Views?
If yes, then create Analytic Privileges for the views and assign them to the User
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.