cancel
Showing results for 
Search instead for 
Did you mean: 

HR Table restriction on SAP ECC HANA database

sanjeevanand
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

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

0 Kudos

Hello Sanjeev.S,

I have the same issue, did you ever find a solution?

Best regards,

Cristina

sanjeevanand
Explorer

Hi Christina,

We are accomplishing this by below procedure as we don't find any standard way from SAP to restrict this.

1) Restrict access for standard schema in repository roles.

2) Create a dummy catalog role.

3) using store procedure to update the catalog role with all sap tables other than sensitive tables.

4) Call this catalog role in the repository role needed.

Thanks,

Sanjeev.S

sanjeevanand
Explorer
0 Kudos

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.