Skip to Content
0

HR Table restriction on SAP ECC HANA database

Dec 14, 2016 at 05:44 PM

90

avatar image

Hello Everyone,

We have recently migrated to ECC Hana data base and there are few developers who need access to HANA database.

The developer says that he needs access for SAP default schema which gives access for all tables in SAP and they are worried that creating customized schema with tables they need may involve more work as they need to replicate the data each time to default schema each time and they need access to most of the tables in SAP

Please advise Is there a way that we can restrict HR /critical tables from SAP default schema so that developer cannot query the data in ECC database.

Please advise on the correct approach on this issue.

Thanks,

Sanjeev.S

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Harish Karra Dec 14, 2016 at 05:50 PM
1

Hi Sanjeev,

Below link has few solutions to achieve this. Rather than giving full access on entire schema give required access only on particular tables OR create a custom role with access on Schema but not on specific tables.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/f674e1751910148a8b990d33efbdc5/content.htm

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
Sanjeevanand Selvan Dec 14, 2016 at 06:06 PM
0

Harish , Thanks for your reply.. I have already created a custom role using WEB IDE which gives select access for SAP default schema.

However I don't see any further option to restrict the table from viewing. The minimum access I could give for the table is select which gives access for viewing the contents in the table. Please let me know is there any field which could restrict on table from viewing.

Share
10 |10000 characters needed characters left characters exceeded