Skip to Content
0
Dec 14, 2016 at 05:44 PM

HR Table restriction on SAP ECC HANA database

401 Views

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