on 04-19-2015 3:48 PM
Hi Friends,
I work on SAP HANA Studio and have access to "SYSTEM" user account which is an Admin loaded with all kinds of privileges.
I created an ODATA service by creating the Workspace then the Project etc.
All required steps were followed and I am able to access(view output)this service from my browser.I want to consume my Odata service in an SAPUI5 app and the steps for the same are known.
But the issue is I want all these activities to be done by USER with limited privileges (and not access the SYSTEM user)
Kindly provide me the List and Explanation of all the necessary privileges which are needed to create a Role to do the above mentioned activities.
FYI I have basic understanding of Privileges in the Modelling role and also used some of them to create a customized Role for Trainees in the past.
Thanks a lot friends.I need urgent help on this matter.
Hi Prateek,
For development, purposes, you can assign below privileges to the developer:
I would also suggest you to create hdbrole and not the catalog role that is created using GUI in HANA Studio
system privilege: CATALOG READ; (to grant read only access to system views)
catalog schema "_SYS_BI": SELECT; (_SYS_BI contains metadata of information models)
catalog schema "_SYS_BIC": SELECT;(_SYS_BIC contains activated data models and procedures)
catalog schema "_SYS_BIC": EXECUTE;
catalog sql object "SYS"."REPOSITORY_REST": EXECUTE;
catalog analytic privilege: "_SYS_BI_CP_ALL";
Either you can give access to Root package or access to particular package where a user can create objects
package ".REPO_PACKAGE_ROOT": REPO.READ;
package ".REPO_PACKAGE_ROOT": REPO.EDIT_NATIVE_OBJECTS;
package ".REPO_PACKAGE_ROOT": REPO.ACTIVATE_NATIVE_OBJECTS;
package ".REPO_PACKAGE_ROOT": REPO.MAINTAIN_NATIVE_PACKAGES;
If you also want user to create models, then grant below privilege:
system privilege: CREATE SCENARIO;
Also grant him the access to schema in which tables are present
You should go through below document for more details:
http://help.sap.com/hana/SAP_HANA_Security_Guide_en.pdf
Additionally, you can also check my blog:
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 |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.